CPA Map Competencies
Background
Custom Canadian Cycles (CCC) is a bike manufacturer based in Ontario, Canada who specializes in selling custom bikes alongside a variety of bike accessories and safety equipment. CCC sells bikes in both Canada and Germany.
Today is October 30th, 2022, and you, a Financial Controller at CCC, have been tasked with spearheading CCC’s expansion into the United States market in fiscal 2023. CCC has put together a US Expansion sub-committee to determine the logistics surrounding this expansion.
From your company’s database, you have gathered sales data related to the past eight years (2015 – 2022), However, you know that this information alone is not sufficient for decision making and needs to be organized so that you may gain insight into what a successful expansion will look like.
Based on your preliminary discussions with your colleagues, you have been able to learn the following:
Information Available
You have access to CCC’s sales data from 2015 to 2022. This sales data contains various sales information generated by their enterprise resource planning software ranging from order numbers to profit margins per sale.
Part
1: Data Cleaning & Preparation
One of the core ideas behind the accounting profession is helping people make decisions. In the case of management accounting, managers need to have relevant information that allows them to achieve their company’s strategic and operational objectives. Raw data will not allow managers to make effective decisions, and therefore, requires “cleaning” to maximize the effectiveness of their decision making.
a) Examine the provided dataset. Identify data that is not likely to be relevant in your analysis and anything that presents ethical/privacy issues (Think about what data may be most relevant to the US market). Remove this data from your data set.
b) Due to issues with CCC`s systems, certain transactions were not recorded correctly and were displayed in their database as blank cells. Remove the rows of transactions with incomplete information
c) Using PivotTables, create visual representations of total unit sales and profit margin for each category of bike sold by CCC.
d) (Bonus) Use Microsoft PowerBI to perform part c)
2: Memorandum to Management Regarding Market Expansion Analysis
Based on your analysis performed in Part 1, prepare a memo to the sub-committee discussing:
1. The data you used to come to your decision 2. Any issues you have found with the sales data (i.e. Security issues, administrative, etc.)
3. Your analysis on which bikes should be sold to the US market.
4. Which two bikes should be introduced to the US market?
BEN02 Planning and Presenting a Micro-Enterprise Idea BTEC Level 1/2
Read MoreBTEC Unit 35: Engineering Services Delivery Plan for Sector-Specific Organizations | HND Level 5 Assignment 2
Read MoreTQUK Level 3 Administering Medication and Monitoring Effects in Adult Care Assignment
Read MoreUnit 10: 3D Modelling and Assembly Drawing for Vice – Engineering Design Portfolio BTEC Level 3
Read MoreWhy is it important that you correlate the appropriate information of the patient when they arrive for their appointment?
Read MoreNCFE Level 3 Roles and Responsibilities in Health And Social Care
Read MoreMP3395 Turbocharger Performance Evaluation and System Analysis CW2 Assessment, AY2024-25
Read MoreKey Research Policies and Funding Models at University of Strathclyde
Read MoreCIPD Level 5 Associate Diploma Key Assessment Questions
Read MoreLaw Assignment Questions Critical Legal Analysis & Solutions
Read More