Question
Managerial Accounting Problem: Using Microsoft Excel (Show calculations/work) Problem #1: S. Miller Company has been experiencing losses for some time, as shown by its most
Managerial Accounting Problem: Using Microsoft Excel (Show calculations/work)
Problem #1: S. Miller Company has been experiencing losses for some time, as shown by its most recent monthly contribution format income statement:
Sales | $ 1,590,000 |
Variable expenses | 701,000 |
Contribution margin | 889,000 |
Fixed expenses | 978,000 |
Net operating income (loss) | $ (89,000) |
In an effort to resolve the problem, the company would like to prepare an income statement segmented by division. Accordingly, the Accounting Department has developed the following information:
Red | Blue | Green | |
Sales | $ 380,000 | $ 660,000 | $ 550,000 |
Variable expenses as a percentage of sales | 60% | 30% | 50% |
Traceable fixed expenses | $ 265,000 | $ 339,000 | $ 198,000 |
Requirements:
1. Prepare a contribution format income statement segmented by divisions.
2a. The Marketing Department has proposed increasing the Green Division's monthly advertising by $26,000 based on the belief that it would increase that division's sales by 17%. Assuming these estimates are accurate, how much would the company's net operating income increase (decrease) if the proposal is implemented?
2b. Would you recommend the increased advertising? Why or why not?
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Problem #2: Mikes Bikes, Incorporated, produces and sells many bicycles. The company has just opened a new plant to produce a new tricycle that will be marketed throughout the United States. The following cost and revenue data relate to May, the first month of the plants operation:
Beginning inventory | 0 |
Units produced | 45,000 |
Units sold | 40,000 |
Selling price per unit | $ 79 |
Selling and administrative expenses: | |
Variable per unit | $ 3 |
Fixed (per month) | $ 566,000 |
Manufacturing costs: | |
Direct materials cost per unit | $ 15 |
Direct labor cost per unit | $ 8 |
Variable manufacturing overhead cost per unit | $ 3 |
Fixed manufacturing overhead cost (per month) | $ 855,000 |
Management is anxious to assess the profitability of the new tricycle during the month of May.
Requirements:
1. Assume that the company uses absorption costing.
1a. Calculate the unit product cost.
1b. Prepare an income statement for May.
2. Assume that the company uses variable costing.
2a. Calculate the unit product cost.
2b. Prepare a contribution format income statement for May.
3. Explain the reason for any difference in the ending inventory balances under the two costing methods and the impact of this difference on reported income.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started