if someone would help with this problme in excel format that will be great. thbak you ahead of time and will add a like to the solution!.
Calgary Products Ltd. has just created a new division to manufacture and sell a fitness tracker. The facility is highly automated and has high monthly fixed costs, as shown in the following schedule of budgeted monthly costs. This schedule was prepared based on an expectation of a monthly production volume of 2,400 units. Manufacturing costs: Direct materials per unit $35 Direct manufacturing labour per unit $25 Variable manufacturing overhead per unit $20 Total fixed manufacturing overhead $90,000 per month Marketing costs: 8% of sales 566,000 per month Variable marketing Total fixed marketing overhead The selling price per unit is $240. The following activity was recorded: October Units produced 2,000 Units sold 1,400 November 2.500 2,800 Required In Excel, create a solution with one excel tab labelled "Actual" and one tab labelled "Standard" (DO NOT se my spreadsheets.) All cells on the income statement MUST be linked to the raw data that is shown at the top of each spreadsheet. Your solution needs to have the following items in the following order: The tab called "ACTUAL" MUST contain: d. Raw data for units and all costs for ACTUAL costing AT THE TOP OF THE SPREADSHEET b. Variable costing contribution margin) income statement using ACTUAL costing for October and November c. Absorption costing (gross margin) income statement using ACTUAL costing for October and November The tab called "STANDARD" MUST contain: 1 d. Raw data for units and all costs for STANDARD costing AT THE TOP OF THE SPREADSHEET e. Variable costing contribution margin) Income statement using STANDARD costing for October and November f. Absorption costing (gross margin) income statement using STANDARD costing for October and November The raw data for your question is on the following page. You can use any reference material as it is open book. However, discussions need to be kept between you and your partner