Assignment
Step 1: Choose the Profit-Maximizing Output Level
The CEO's next question is, "What level of output would be required to maximize our profit on the Android01?" You have calculated the variable cost-per-unit for different levels of production. From market research, you have a schedule of prices for these levels. The information is summarized in the table below:
|
Number of Units
|
Variable Cost-per-Unit ($)
|
Sale Price-per-Unit ($)
|
|
200
|
60,000
|
70,000
|
|
250
|
54,000
|
66,000
|
|
300
|
48,000
|
64,000
|
|
350
|
46,000
|
59,000
|
|
400
|
45,000
|
52,000
|
A recommendation on output could affect everyone in the company, from management to sales, to the floor manager and assembly line workers! You don't want to get this one wrong so you take some extra time to proof your calculations.
Question 1: Based on profit-maximization analysis, what level of output should you recommend to the CEO?
Before starting your calculations, review materials on profit maximization output.
Submit your Profit-Maximization Output Report and Calculations to the dropbox below. Submit a spreadsheet showing your calculations in Excel and provide a narrative analysis in Word. Your narrative analysis should summarize the results of your analysis and make recommendations for the benefit of the company.
Step 2: Budget
Your CEO has asked you to prepare a production cost budget for the MiniY for May 20X8. The actual costs in April 20X8 were:
|
MiniY: Production Cost Budget
|
|
April 20X8
|
|
Production-Units of MiniY
|
3,000
|
|
Components cost (variable)
|
24,000,000
|
|
Labor cost (variable)
|
13,500,000
|
|
Rent (fixed)
|
6,000,000
|
|
Depreciation (fixed)
|
6,000,000
|
|
Other (fixed)
|
2,000,000
|
|
Total
|
$51,500,000
|
For the month of May, the number of MiniY produced will increase to 3,200, reflecting an anticipated sales increase related to a new marketing campaign.
Question 2: Using the above information, prepare a budget for May 20X8 stating the total cost. Use a spreadsheet to display your data and calculations.
Before starting your calculations, review materials on integrating accounting and financial information.
Submit a spreadsheet showing your calculations in Excel and provide a narrative analysis in Word. Your narrative analysis should summarize the results of your analysis and make recommendations for the benefit of company.
Step 3: Profit or Loss
IPS operates a factory which produces the MiniY and the MiniX. During September 20X8, the factory produced 3200 units of MiniY and 3000 units of MiniX. The joint cost related to the operation was $3,000,000. MiniX sells for $27,100 per unit and MiniY sells for $25,000 per unit. Allocate the joint costs using the relative sales values of MiniY and MiniX.
Question 3: With the costs that you calculate, what is the profit or loss associated with MiniY? NOTE: Assume that the variable and fixed costs mentioned in Step 2 are also applicable to Step 3 when calculating the profit or loss for MiniY
Before starting your calculations, review the materials on integrating accounting and financial information.
Submit a spreadsheet showing your calculations in Excel and provide a narrative analysis in Word. Your narrative analysis should summarize the results of your analysis and make recommendations for the benefit of the company.
Step 4: Managerial Accounting Report to Management
Write an Executive Summary and add Fidnings and recommendations.