Question
In: Accounting
Redford Corporation Manufacturing Budget Redford Corporation, a maker of high-strength umbrellas, is preparing a preliminary manufacturing...
| Redford Corporation | ||||||||||||
| Manufacturing Budget | ||||||||||||
| Redford Corporation, a maker of high-strength umbrellas, is preparing a preliminary manufacturing budget for the year 2019 | ||||||||||||
| They have gathered the following estimate data from various teams: | ||||||||||||
| Production units | 400,000 | |||||||||||
| Materials - metal rods/clasps | $ 0.40 | per unit, before wastage | ||||||||||
| Materials - high-strength fabric | $ 1.20 | Per sq. yard | ||||||||||
| Materials - Resin handles | $ 0.25 | per unit | ||||||||||
| Direct Labor - Cutting and Assembly Line | $ 28.00 | Per hour | ||||||||||
| Packing & Inspection Costs (variable) | $ 300.00 | Per batch | ||||||||||
| Factory fixed costs | $ 300,000 | Per Year | ||||||||||
| Additional information given: | ||||||||||||
| Roughly 5% of metal parts are damaged or defective and are discarded as wastage | ||||||||||||
| Each umbrella uses 1.5 sq. yards of high-strength fabric | ||||||||||||
| Roughly 10% of the initial fabric quantity is not usable in the umbrellas due to the cutting process, but 20% of the value of this fabric is recovered by selling the unused pieces to a dealer | ||||||||||||
| The current process uses roughly 20 hours of direct labor (cutting and assembly line) per batch of umbrellas | ||||||||||||
| Each batch has 200 umbrellas | ||||||||||||
| Q1. Prepare a Manufacturing Cost Budget for 2019 by quarter, assuming flat activity and equal-length quarters (do not adjust for days) | ||||||||||||
| Q2. Prepare a High Case budget alternative assuming that production ramps up 50% in the second half. | ||||||||||||
| In this scenario, assume fixed costs increase by $60,000/yr due to need for additional storage space, while variable cost structure is unchanged | ||||||||||||
Solutions
Expert Solution
| Requirement Q1 | |||||
| Manufacturing cost budget for 2019 | |||||
| Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Total | |
| production units | 100,000 | 100,000 | 100,000 | 100,000 | 400,000 |
| Materials-metal rods/clasps | $40,000 | $40,000 | $40,000 | $40,000 | $160,000 |
| Materials-High strengh Fabric | $176,400 | $176,400 | $176,400 | $176,400 | $705,600 |
| Materials Resin handles | $25,000 | $25,000 | $25,000 | $25,000 | $100,000 |
| Direct cutting and assembly | $280,000 | $280,000 | $280,000 | $280,000 | $1,120,000 |
| Packing and inspection costs | $150,000 | $150,000 | $150,000 | $150,000 | $600,000 |
| Fixed Factory cost | $75,000 | $75,000 | $75,000 | $75,000 | $300,000 |
| Total manufacturing cost | $746,400 | $746,400 | $746,400 | $746,400 | $2,985,600 |
| Working Notes | ||
| Materials -metals & clasps (100000*0.40) | 40000 | For Each Qtr |
| Materials-High strength fabric (100000*1.2*1.5) | 180000 | |
| Less : Value of fabric
recoved 180000*10%*20% |
3600 | |
| Net Materials cost of fabric | 176400 | For each quarter |
| Materials Resin handles (100000*0.25) |
25000 | For each quarter |
| Direct cutting and
assembly (20/200*28*100000) |
280000 | For each quarter |
| Packing and inspection
costs (100000/200*300) |
150000 | For each quarter |
| Fixed Factory cost (300000/4) |
75000 | For each quarter |
| Requirement Q2 | |||||
| Manufacturing cost budget for 2019 | |||||
| Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Total | |
| production units | 100000 | 100000 | 150000 | 150000 | 500000 |
| Materials-metal rods/clasps | $40,000 | $40,000 | $60,000 | $60,000 | $200,000 |
| Materials-High strengh Fabric | $176,400 | $176,400 | $264,600 | $264,600 | $882,000 |
| Materials Resin handles | $25,000 | $25,000 | $37,500 | $37,500 | $125,000 |
| Direct cutting and assembly | $280,000 | $280,000 | $420,000 | $420,000 | $1,400,000 |
| Packing and inspection costs | $150,000 | $150,000 | $225,000 | $225,000 | $750,000 |
| Fixed Factory cost | $75,000 | $75,000 | $105,000 | $105,000 | $360,000 |
| Total manufacturing cost | $746,400 | $746,400 | $1,112,100 | $1,112,100 | $3,717,000 |
| Working Notes | ||
| Materials -metals &
clasps (150000*0.4) |
60000 | For each quarter of second half |
| Materials-High strength
fabric (150000*1.2*1.5) |
270000 | |
| Less : Value of fabric
recoved (270000*10%*20%) |
5400 | |
| Net Materials cost of fabric | 264600 | For each quarter of second half |
| Materials Resin handles (150000*0.25) |
37500 | For each quarter of second half |
| Direct cutting and
assembly (20/200*28*150000) |
420000 | For each quarter of second half |
| Packing and inspection
costs (150000/200*300) |
225000 | For each quarter of second half |
| Fixed Factory cost (300000/4+30000) |
105000 | For each quarter of second half |
| Note: Increased in fixed factory cost by $60000 can be allocated to all quarters equally. However, we have assumed that additional storage space is hired in second half and thus allocated this cost to quarters of Second Half only. |
ekkarill92 answered 1 year agoRelated Solutions
Redford Corporation Manufacturing Budget Redford Corporation, a maker of high-strength umbrellas, is preparing a preliminary manufacturing...
Redford Corporation
Manufacturing Budget
Redford Corporation, a maker of high-strength umbrellas, is
preparing a preliminary manufacturing budget for the year 2019
They have gathered the following estimate data from various
teams:
Production units
400,000
Materials - metal rods/clasps
$
0.40
per unit, before wastage
Materials - high-strength fabric
$
1.20
Per sq. yard
Materials - Resin handles
$
0.25
per unit
Direct Labor - Cutting and Assembly Line
$ 28.00
Per hour
Packing & Inspection Costs (variable)
$ 300.00
Per...
Redford Corporation Manufacturing Budget Redford Corporation, a maker of high-strength umbrellas, is preparing a preliminary manufacturing...
Redford Corporation
Manufacturing Budget
Redford Corporation, a maker of high-strength umbrellas, is
preparing a preliminary manufacturing budget for the year 2019.
They have gathered the following estimate data from various
teams:
Production units
400,000
Materials - metal rods/clasps
$0.40
per unit, before wastage
Materials - high-strength fabric
$1.20
Per sq. yard
Materials - Resin handles
$0.25
per unit
Direct Labor - Cutting and Assembly Line
$28.00
Per hour
Packing & Inspection Costs (variable)
$300.00
Per batch
Factory fixed costs
$ ...
E21-11 prepare a manufacturing overhead budget for the year Atlanta Company is preparing its manufacturing overhead budget...
E21-11 prepare a manufacturing overhead budget for the
year
Atlanta Company is preparing its manufacturing overhead budget for
2017. Relevant data
consist of the following.
Units to be produced (by quarters): 10,000, 12,000,
14,000, 16,000.
Direct labor: time is 1.5 hour per unit.
Variable overhead costs per direct labor hour: indirect
materials $0.80; indirect labor
$1.20; and maintenance $0.50.
Fixed overhead costs per quarter: supervisory salaries
$35,000; depreciation $15,000;
and maintenance $12,000.
Instructions
Prepare the manufacturing overhead budget for the year; showing
quarterly data.
ATLANTA...
Petesy Corporation is preparing its Master Budget for 2019. Budget information is as follows: &nb
Petesy Corporation is preparing its
Master Budget for 2019. Budget information is as follows:
Sales
Production
Cost
Operating Expenses
2019
1st
Quarter
P280,000
P192,000
P64,000
2nd
Quarter
320,000
200,000
68,000
3rd
Quarter
360,000
224,000
72,000
4th
Quarter
352,000
200,000
76,000
2020
1st
Quarter
320,000
224,000
72,000
The budgeted Finished Goods
Inventories are:
2018 March
31
P56,000
June
30
52,000
September 30 60,000
December 31 48,000
The company uses...
Millen Corporation is a merchandiser that is preparing a master budget for the month of July....
Millen Corporation is a merchandiser that is preparing a master
budget for the month of July. The company’s balance sheet as of
June 30th is shown below:
Millen Corporation
Balance Sheet
June 30
Assets
Cash
$
120,000
Accounts receivable
166,000
Inventory
37,200
Plant and equipment, net of depreciation
554,800
Total assets
$
878,000
Liabilities and Stockholders’ Equity
Accounts payable
$
93,000
Common stock
586,000
Retained earnings
199,000
Total liabilities and stockholders’ equity
$
878,000
Millen’s managers have made the following...
Millen Corporation is a merchandiser that is preparing a master budget for the month of July....
Millen Corporation is a merchandiser that is preparing a master
budget for the month of July. The company’s balance sheet as of
June 30th is shown below:
Millen Corporation
Balance Sheet
June 30
Assets
Cash $ 120,000
Accounts receivable 166,000
Inventory 37,200
Plant and equipment, net of depreciation 554,800
Total assets $ 878,000
Liabilities and Stockholders’ Equity
Accounts payable $ 93,000
Common stock 586,000
Retained earnings 199,000
Total liabilities and stockholders’ equity $ 878,000
Millen’s managers have made the following...
Colerain Corporation is a merchandising company that is preparing a budget for the third quarter of...
Colerain Corporation is a merchandising company that is
preparing a budget for the third quarter of the calendar year. The
company’s balance sheet as of June 30 is shown below:
COLERAIN CORPORATION
Balance Sheet
June 30
Assets
Cash
$ 88,000
Accounts receivable
134,000
Inventory
60,000
Plant and equipment, net of depreciation
280,000
Total assets
$ 562,000
Liabilities and Shareholders’ Equity
Accounts payable
$ 69,000
Common shares
380,000
Retained earnings
113,000
Total liabilities and shareholders’ equity
$ 562,000
Colerain’s managers have...
Colerain Corporation is a merchandising company that is preparing a budget for the third quarter of...
Colerain Corporation is a merchandising company that is
preparing a budget for the third quarter of the calendar year. The
company’s balance sheet as of June 30 is shown below:
COLERAIN CORPORATION
Balance Sheet
June 30
Assets
Cash
$
100,000
Accounts
receivable
146,000
Inventory
72,000
Plant and equipment,
net of depreciation
400,000
Total assets
$ 718,000
Liabilities and Stockholders’ Equity
Accounts
payable
$
81,000
Common shares
500,000
Retained
earnings
137,000
Total liabilities
and stockholders’ equity
$ 718,000
Colerain’s managers have...
Colerain Corporation is a merchandising company that is preparing a budget for the third quarter of...
Colerain Corporation is a merchandising company that is
preparing a budget for the third quarter of the calendar year. The
company’s balance sheet as of June 30 is shown below:
COLERAIN CORPORATION
Balance Sheet
June 30
Assets
Cash
$ 95,000
Accounts receivable
141,000
Inventory
67,000
Plant and equipment, net of depreciation
350,000
Total assets
$ 653,000
Liabilities and Shareholders’ Equity
Accounts payable
$ 76,000
Common shares
450,000
Retained earnings
127,000
Total liabilities and shareholders’ equity
$ 653,000
Colerain’s managers have...
Dalton Manufacturing is preparing its master budget for the first quarter of the upcoming year. The...
Dalton Manufacturing is preparing its master budget for the
first quarter of the upcoming year. The following data pertain to
Dalton Manufacturing's operations:
Current Assets as of December 31 (prior year):
Cash. . . . . . . . . . . . . . . . . . . . . . . . . .
.$4,460
Accounts receivable, net. . . . . . . . . . . $48,000
Inventory. . . . . . . ....
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Calculate the ideal age of a spouse. Enter either m or f from the keyboard in...
- Due to a recession, expected inflation this year is only 4.75%. However, the inflation rate in...
- What are the benefits of doing a pilot program before a full scale rollout of a...
- It is a calm summer day in southeast Iowa at the Ottumwa air traffic control radar...
- 1. Write a detailed article on Evolution of attacks on the internet & web [your article...
- Analyze the role of the contingency plan coordinator (CPC) in the scope of preparing a BIA....
- Amazing Manufacturing, Inc., has been considering the purchase of a new manufacturing facility for $500,000. The...
ADVERTISEMENT