Corresponding Working Notes are given against the blank cell as reference. Look for those working notes below. Feel free to comment below if you have any more doubts.
WN 1.
% Increase Material = ($65,500 - $51,000) / $51,000 = 28% (Rounded)
WN 2
Status Quo Labour = Let be Y
($65,500 - $Y) / $Y = 25%
Y = $52,400
WN 3
% Increase depreciation = 0% (Since no change)
WN 4
Difference in utilities = $1,150
So status quo Utilities = $6,000 - $1,550 = $4,550
% Increase Utility = ($6,100 - $4,550) / $4,550 = 34% (Rounded)
WN 5
Incremental profit = 10.5% of incremental revenue = 10.5% x $71,000 = $7,455
WN 6
Let Status quo sale be P
Therefor P x 25% = $71,000
P = $2,84,000
Alternative Sales = $2,84,000 x 125% = $3,55,000
WN 7
Status quo operating profit = 25% of Sales revenue = 25% x 284,000 = $71,000
WN 8
Total Costs = Sales revenue - Operating profit = $284,000 - $71,000 = $213,000
WN 9
At status quo, other costs = 2 x cost of rent
Let Cost of rent be R, so other cost will be 2R
Total costs = $2,13,000 Identified costs till now = $1,17,050 Unidentified costs =$2,13,000 - $1,17,050 =$95,950
$95,950 = R + 2R
R = $31,983 = Rent
2R = $63,967 = Other costs
WN 10
Alternative Rent = $31,983 + 40% = $44,776 (Rounded off)
WN 11
Alternative operating profit = Status quo operating profit + $7,455 = $78,455
WN 12
Alternative Total costs = Alternative sales - Alternative operating profit = $355,000 - $78,455 = $276,545
WN 13
Alternative Other costs = Total Costs - Identified costs = $276,545 - $190,976 =
miller cereals is a small milling company that makes a single brand of cereal. aps TOUTUDe...
Miller Cereals is a small milling company that makes a single brand of cereal. Recently, a business school intern recommended that the company introduce a second cereal in order to “diversify the product portfolio.” Currently, the company shows an operating profit that is 20 percent of sales. With the single product, other costs were twice the cost of rent. The intern estimated that the incremental profit of the new cereal would only be 3.5 percent of the incremental revenue, but...
Miller Cereals is a small milling company that makes a single
brand of cereal. Recently, a business school intern recommended
that the company introduce a second cereal in order to “diversify
the product portfolio.” Currently, the company shows an operating
profit that is 25 percent of sales. With the single product, other
costs were twice the cost of rent.
The intern estimated that the incremental profit of the new
cereal would only be 3.5 percent of the incremental revenue, but...
Required: As the management accountant, fill in the blank cells. (Do not round intermediate calculations. Round your final answers to the nearest whole number. Enter all amounts as positive values.) Miller Cereals Projected Income Statement For One Year Status Quo: % Increase Alternative: Single Product (Decrease) Two Products 25 % Difference $ 67,000 Sales revenue Costs Material 47,000 % 63,500 Labor 25 % 63,500 Rent 40 % 8,700 % 8,700 Depreciation Utilities % 5,700 1,350 Other Total costs Operating profit...
I'm confused on how to do this problem, especially
when calculating the rent and labor rates.
I tried looking at similar questions, but they didn't
explain how they got the decimals.
Chapter 1 Cost Accounting: Information for Decision Making 1-54. Cost Data for Managerial Purposes-Finding Unknowns (LO 1-3) Miller Cereals is a small milling company als is a small milling company that makes a single brand of cereal. Recently, a business school intern recon intern recommended that the company introduce...
I need help with calculating the numbers in this problem. I have
been stuck on it for days. I apologize if my formatting isn't the
best, this is the first time I've posted a question.
Case 1 A Saved Help Save & Exit Submit You received partial credit in the previous attempt. Check my work View previous attempt Miller Cereals is a small milling company that makes a single brand of cereal. Recently, a business school intern recommended that the...
You are a marketing manager for a company that makes ready-to-eat breakfast cereals. Your company recently initiated a loyalty program for consumers, which resulted in a large purchaser database. The brand managers are eager to mine the available data, which they can use to design more effective promotional programs. The management of your organization believes that to be effective, these programs have to take into account significant cross-region (i.e., the East Coast, the West Coast, the Midwest, and the South)...
Endless Mountain Company manufactures a single product that is
popular with outdoor recreation enthusiasts. The company sells its
product to retailers throughout the northeastern quadrant of the
United States. It is in the process of creating a master budget for
2022 and reports a balance sheet at December 31, 2021 as
follows:
Endless Mountain Company
Balance Sheet
December 31, 2021
Assets
Current assets:
Cash
$
46,200
Accounts receivable (net)
260,000
Raw materials inventory (4,500 yards)
11,250
Finished goods inventory (1,500...
Thermal Rising, Inc., makes paragliders for sale through specialty sporting goods stores. The company has a standard paraglider model, but also makes custom-designed paragliders. Management has designed an activity-based costing system with the following activity cost pools and activity rates: 4 Activity Cost Pool Supporting direct labor Order processing Custom design processing Customer service Activity Rate per direct labor-hour $ 194 per order $ 256 per custom design $ 434 per customer Management would like an analysis of the profitability...
Sky Plasties: Activity-Based Costing System Case Study Mr. Sami Sultan, Chairman of Sky Plastics, was studying a schedule showing the product costs for each of the company's three plastic water containers. He had been thinking of how to increase the while facing the international competition for plastic water containers. Usually, Sami time to review company's performance reports. Since profits were being made, Sami believed that company's exports did not spend a lot of accounting to was the responsibility of the...
Polaski Company manufactures and sells a single product called a Ret Operating at capacity, the company can produce and sell 36.000 Rets per year. Costs associated with this level of production and sales are given below: Unit $ 25 Direct materials Direct labor variable manufacturing overhead Fixed manufacturing overhead Variable selling expense Fixed selling expense Total cost 3 7 4 6 Total $ 9ee, eee 288,000 188, eee 252, eee 144,000 216,080 $ 1,908,000 $ 53 The Rets normally sell...