Question

In: Accounting

MONTH UNITS TOTAL COSTS PRODUCED January 12,500 $430,000 February 17,000 $490,000 March 19,000 $512,000 April 10,000...

MONTH UNITS TOTAL COSTS PRODUCED

January 12,500 $430,000

February 17,000 $490,000

March 19,000 $512,000

April 10,000 $400,000

May 14,000 $434,000

June 9,000 $360,000

July 20,000 $550,000

August 21,000 $525,000

September 24,000 $605,000

October 23,000 $589,000

November 28,000 $702,000

December 18,000 $496,000

1) From this information, what are my approximate fixed costs and what is my estimated variable cost per product produced? (20 POINTS) Fixed Costs = Variable Cost per Unit =

2) If I manufacture 35,000 units this month, what are my projected total costs? (10 POINTS) Total Costs =

3) If my total costs this month can not exceed $600,000, approximately how many units can I produce? (10 POINTS) Units produced =

4) Produce a figure of your choosing that presents Units Produced for each month. (20 POINTS)

Solutions

Expert Solution

Question 1:

Question 2:

Question 3:

Question 4:

** Please feel free to leave a comment if any more explanations are required. Please hit the thumbs up button if it was helpful.

Thank You..!!

ekkarill92 answered 2 years ago
Next > < Previous

Related Solutions

Month: Radiology Tests:   Total Costs: January 2,800    $133,500 February 2,600 $135,060 March 3,100 $175,000 April...
Month: Radiology Tests:   Total Costs: January 2,800    $133,500 February 2,600 $135,060 March 3,100 $175,000 April 3,500 $170,600 May 3,400 $176,900 June 3,700 $186,600 July 3,840 $174,450 August 4,100 $195,510 September 3,450 $15,300 1. Compute the cost formula for radiology services using the method of least square 2. Using the formula computed in requirement 1, what is the predicted cost of radiology services for October for 3,500 appointments? (Round the answer to the nearest dollar) 3. What does the coefficient...
Question 1: - Cash Budget: Estimated sales January February March April May Total Coffee sales (units)...
Question 1: - Cash Budget: Estimated sales January February March April May Total Coffee sales (units) 15,000 16,000 17,500 18,000 14,500 Your friend, MATT, has been running a successful coffee shop for the last couple of years. He has asked you to put together a cash budget. His regular accountant was too busy to help, but told MATT his depreciation expense was going to be $1,800 per year, using the straight-line method. He has supplied you with the following information...
1.   Sales forecast: January: 2,600 units; February: 4,500 units; March: 10,200 units; April: 12,000 units. The...
1.   Sales forecast: January: 2,600 units; February: 4,500 units; March: 10,200 units; April: 12,000 units. The unit sales price is $125. All sales are on credit and collections are 30% in the month of sale, 60% the following month, and 10% two months following the sale. Accounts receivable as of the end of December is $4,600 and this amount is expected to be collected in January. 2. End of month inventory must equal 40% of next month’s sales. The inventory...
1.   Sales forecast: January: 2,600 units; February: 4,500 units; March: 10,200 units; April: 12,000 units. The...
1.   Sales forecast: January: 2,600 units; February: 4,500 units; March: 10,200 units; April: 12,000 units. The unit sales price is $125. All sales are on credit and collections are 30% in the month of sale, 60% the following month, and 10% two months following the sale. Accounts receivable as of the end of December is $4,600 and this amount is expected to be collected in January. 2. End of month inventory must equal 40% of next month’s sales. The inventory...
Estimated sales January February March April May Total Coffee sales (units) 15,000 16,000 18,000 17,500 14,500...
Estimated sales January February March April May Total Coffee sales (units) 15,000 16,000 18,000 17,500 14,500 Your friend, Chris Coffee, has been running a successful coffee shop for the last couple of years. He has asked you to put together a cash budget. His regular accountant was too busy to help, but told Chris his depreciation expense was going to be $9,000 per year, using the straight-line method. He has supplied you with the following information (above) to help you...
Cash Budget: Estimated sales January February March April May Total Coffee sales (units) 15,000 16,000 17,500...
Cash Budget: Estimated sales January February March April May Total Coffee sales (units) 15,000 16,000 17,500 18,000 14,500 Your friend, Chris Coffee, has been running a successful coffee shop for the last couple of years. He has asked you to put together a cash budget. His regular accountant was too busy to help, but told Chris his depreciation expense was going to be $1,800 per year, using the straight-line method. He has supplied you with the following information (above) to...
Information for 2020: 1.   Sales forecast: January: 2,600 units; February: 4,500 units; March: 10,200 units; April:...
Information for 2020: 1.   Sales forecast: January: 2,600 units; February: 4,500 units; March: 10,200 units; April: 12,000 units. The unit sales price is $125. All sales are on credit and collections are 30% in the month of sale, 60% the following month, and 10% two months following the sale. Accounts receivable as of the end of December is $4,600 and this amount is expected to be collected in January. 2. End of month inventory must equal 40% of next month’s...
Information for 2019: 1.   Sales forecast: January: 2,100 units; February: 2,900 units; March: 3,300 units; April:...
Information for 2019: 1.   Sales forecast: January: 2,100 units; February: 2,900 units; March: 3,300 units; April: 3,500 units. The unit sales price is $50. All sales are on credit and collections are 20% in the month of sale and 80% the following month. Accounts receivable as of December 31, 2018 is $15,000 and this amount is expected to be collected in January 2019. 2. End of month inventory must equal 60% of next month’s sales. The inventory at the end...
1. Month Total Maintenance Cost Production Volume (units) January $ 1,980 1,850 units February $ 1,800...
1. Month Total Maintenance Cost Production Volume (units) January $ 1,980 1,850 units February $ 1,800 1,500 units March $ 2,200 2,600 units April $ 2,180 2,275 units May $ 2,300 2,750 units Using the high-low method, the variable rate for maintenance is: Multiple Choice $0.40. $0.75. $1.50. $2.00. 2. The current cost structure for the production department of Performance, Inc., has fixed expenses of $500,000 and variable expenses of $200 per unit. Unit sales volume is 6,000 units. Performance,...
Lacourse Inc.'s inspection costs are listed below: Units Produced Inspection Costs January 415 $ 6,100 February...
Lacourse Inc.'s inspection costs are listed below: Units Produced Inspection Costs January 415 $ 6,100 February 365 $ 5,624 March 434 $ 6,315 April 449 $ 6,453 May 391 $ 5,874 June 366 $ 5,627 July 441 $ 6,380 August 392 $ 5,887 Management believes that inspection cost is a mixed cost that depends on units produced. Using the least-squares regression method, the estimate of the fixed component of inspection cost per month is closest to:
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT