Kathryn Blink
Homework Week 4
The following information relates to Exercises 5-11 through 5-18:
Summit Manufacturing, Inc. produces snow shovels. The selling price per snow shovel is $30. There is no beginning inventory.
Costs involved in production are:
Direct material
$5
Direct labor
$4
Variable manufacturing overhead
$3
Total variable manufacturing costs per unit
$12
Fixed manufacturing overhead cost per year
$180,000
In addition, the company has fixed selling and administrative costs of $160,000 per year.
Exercise 5-11.
During the year, Summit produces 50,000 snow shovels and sells 45,000 snow shovels. What is the value of ending inventory using full costing?
Fixed manufacturing overhead per unit: $3.60
…show more content…
During the year, Summit produces 50,000 snow shovels and sells 45,000 shovels.
What is net income using variable costing?
Net Income Using Variable Costing: $470,000 ($1,350,000-$540,000-$180,000-$160,000)
Exercise 5-18.
During the year, Summit produces 50,000 snow shovels and sells 45,000 shovels.
How much fixed manufacturing overhead is in ending inventory under full costing? Compare this amount to the difference in the net incomes calculated in Exercise 5-13.
Fixed Manufacturing Overhead in Ending Inventory: $18,000 (5,000 units in ending inventory * $3.60 of fixed manufacturing overhead per unit)
As per Exercise 5-13, the difference in net income between variable costing and full costing is the same amount as the fixed manufacturing overhead in ending inventory, as per Exercise 5-18.
Problem 5-2.
A. 2014:
Profit: $695,000 ($225*5,000= $1,125,000 (Revenue); $75*5,000=$375,000 + $50,000/5,000= $85 (Unit Cost); $85*5,000= $425,000 (COGS); $1,125,000-$425,000-$5,000)
Value of Ending Inventory: $0 ($85*0 units in ending inventory)
2015:
Profit: $703,350 ($225*5,000=$1,125,000 (Revenue); $75*6,000=$450,000 + $50,000/6,000= $83.33 (Unit Cost); $83.33*5,000= $416,650 (COGS); $1,125,000-$416,650-$5,000)
Value of Ending Inventory: $83,330 ($83.33*1,000 units in ending inventory)
2016:
Profit: $686,670 ($225*$5,000= $1,125,000 (Revenue); $75*4,000=$300,000 + $50,000/4,000= $87.50 (Unit Cost); $87.50*4,000= $350,000 + $83,330= $433,330
1- The total unit cost = Total Variable Cost + Production Fixed Expenses + Advertising Expense + Selling and Administrative Expense = 3.23 + 1.20 + 0.30 + 0.19 = 4.92.
14. If 11,000 units are produced, what are the total amounts of direct and indirect manufacturing costs incurred to support this level of production?
Second, the manufacturing order costs for non-stocked items was calculated by dividing total manufacturing order costs for non-stocked items by the number of orders for non-stocked products. Non-stocked products have additional costs associated with processing orders that went above and beyond the costs associated with a stocked product. The third step involved determining what the S"A allocation factor would be for calculating the S"A volume related costs. This allocation factor would then be applied to manufacturing COGS. The fourth and final step involved the calculation of the operating profit based on backing out volume related costs from sales revenues followed by deducting S"A and manufacturing order costs from the resulting gross margin to arrive at a operating profit.
5. Regardless of the allocation system used, the total net income for the year will not change because the overall manufacturing overhead cost does not change. However, it is important to use a more accurate allocation method because it allows company’s to make decisions based on specific areas that might be driving costs up that may not show up when costs are allocated based on one driver.
$155M is the net revenue (profilt) per year which was found by dividing total revenue value of $1.2375B by 8 (i.e. $1.2375B/8)
Assume that next year management wants the company to earn a minimum profit of $162,000. How many units be sold to meet this target profit figure? [3 points]
In our second assumption, instead of using the cost of goods per cases in 1986, we try to use the percentage it counts in the total expenses which is 50.4% and to find the sales needed to break-even. The detail of the calculation is shown in the answer for questions d. The result is that 95,635, a little bit higher than the estimated sales of 90,000.
Revenue Estimates Revenue Item 100% Monthly 75% Monthly 50% Monthly Notes Rooms $2,956,500 $2,217,375 $1,478,250 8,100 daily Leases $180,000 $135,000 $90,000 TOTAL REVENUE $3,136,500 $2,352,375 $1,568,250 Expences TOTAL VARIABLE COSTS $454,000 $340,500 $227,000 TOTAL FIXED COSTS $1,403,000 $1,403,001 $1,403,002 TOTAL EXPENSE BEFORE IT $1,857,000 $1,743,501 $1,630,002 EBIT $1,279,500 $608,874 -$61,752 Depreciation $320,000 $320,001 $320,002 EBITDA $1,599,500 $928,875 $258,250 Furnishing Interest $110,000 $110,000 $110,000 20yr Mortgage Interest $182,000 $182,000 $182,000 TOTAL INTEREST $292,000 $292,000 $292,000 TAXES (40%) $395,000.00 $126,749.60 -$141,500.80
1. The local Mastermind store sells innovative educational toys. Part of their service is giving advice to customers about the best toys for a particular age group, which requires having more customer service representatives in the store. During the month long Christmas buying season, it makes half of its $500,000 yearly sales. Its contribution margin on average is 40% and its fixed costs for the year are about $150,000. The owner believes that she could make even higher sales, if she had more customer service representatives on the floor during the peak season. She plans on hiring four more people for 200 hours each at $20 per hour. How much additional revenue does she have earn to the nearest dollar
3. Briefly describe how the current production cost assignment system works. What are the consumption ratios (activity percentages) for assigning manufacturing overhead to each product at present?
* We increased this costs as a percent of revenue 2.7% over the previous year for all forecasted periods
= Unit Selling Price – Unit Variable Cost = $9.00 – ($1.25 + $0.35 + $1.00) = $6.40
If Marlene Herbert were to discontinue place mats, he would miss $270,000 that will go toward Mendel paper company fixed cost. The company currently has a plant overhead that is estimated at $420,000 for the quarter. In addition to the fixed plant overhead, the plant incurs fixed selling and administrative expenses per quarter of $118,000. This draws the company to a total fixed cost of $538,000. If Marlene Herbert were to discontinue the second highest contributor to the fixed cost, he would need to increase the volume of computer paper and lower material cost to help pull the contribution margin of the lowest product up to help support the lost of a whole product line.
2.) For each expense that is variable with respect to revenue hours, calculate the cost per revenue hour.
The revenue is $600,600*1.2= $720,720. The variable cost changes as sales increases and fixed cost stays the same, the gross profit is $175,500. After tax, the net income is $100,557.