Question

Cycle Business manufactures and sells road and mountain bikes through a network of retail outlets in western Canada. Below is a partial list of expense items incurred in the most recent month (November), when 1,030 bicycles were manufactured, shipped, and sold. There was no beginning or ending work in process or finished goods inventory in November: Item Units produced and sold Sales October 930 November 1,030 Leather used for the bicycle seats Production manager's salary Life insurance for the company president Electricity used in the production facilities Sales commissions Internet advertising Employee benefits for the production workerst Property taxes on the production facilities Shipping costs Salary of the chief financial officer $ 930,000 $1,030,000 30,690 33,990 6,150 6,150 215 215 3,835 4,235 45,300 50, 360 1,000 1,000 29,760 32,960 1,150 1,150 45, 300 50, 360 10,300 10,300 *Each month, regardless of how much electricity is used, Cycle Business pays a $115 base charge to the utilities company. Employee benefits total 20% of the wages paid to production workers, who on average earn $20 per hour. Each bicycle requires 8 hours of direct labour. Required: 1. With respect to the partial list of November expenses: a. Use the Type column to label each item as a Manufacturing, Administrative, or Selling cost. b. For those items you labeled as a Manufacturing cost, i. Use the Behaviour column to label each item as variable or fixed manufacturing costs. ii. Use the Direct/Indirect column to label each item as a direct or indirect cost. Item Behaviour Direct/Indirect Direct Variable Fixed Indirect Variable/fixed Indirect Leather used for the bicycle seats Production manager's salary Life insurance for the company president Electricity used in the production facilities Sales commissions Internet advertising Employee benefits for the production workers Property taxes on the production facilities Shipping costs Salary of the chief financial officer Type Manufacturing Manufacturing Administrative Manufacturing Selling Selling Manufacturing Manufacturing Selling Administrative Indirect Variable Fixed Indirect 2. Assume that 1,230 bicycles will be manufactured and sold in December. For the items you classified as manufacturing costs in requirement 1, estimate the cost for December. Assume that there will be no change in unit costs for any direct materials, hourly wages will remain the same, and employee benefits will continue at 20% of wages. Cost $1,242,3351

Hi could you please do question 2, I got the number in the answer box but it is incorrect and I am confused on how what I did wrong. Thank you in advance!

Answer 1

Leather used for Bicycle Seats(1230*$33)	$                                40,590
Production manager salary	$                                  6,150
Electricity used in production facilities[$115+(1230*$4)]	$                                  5,035
Employee benefits for production worker(1230*8 hrs*$20*20%)	$                                39,360
Property taxes on Production facilities	$                                  1,150
Manufacturing Cost for December	$                                92,285
Note:
The Electricity used in production facilities is a Mixed Cost, The Fixed portion is $115 and the Variable portion is as follows:
Variable cost per unit =($4,235 - $3,835) / (1030 - 930) =$400 / 100 units =$4 per unit