Question

In: Accounting

ALASKA MANUFACTURING produces widgets, which they sell for $5 each. They are preparing their budget for...

ALASKA MANUFACTURING produces widgets, which they sell for $5 each. They are preparing their budget for production costs for February 2017. Actual production costs in the previous month, January 2017, were as follows, when production was 20,000 widgets: Raw materials (variable) $ 50,000 Labor costs (variable) 20,000 Factory rent (fixed) 12,000 Equipment depreciation (fixed) 16,000 Other production costs (fixed) 2,000 Total $ 100,000 REQUIRED: 1) What was the prime cost for January, both total AND per-unit? 2) What was the conversion cost of January, both total AND per-unit? 3) ALASKA anticipates that production will rise to 25,000 widgets in February. Using the above numbers as your guide, what would be the expected production cost for February? 4) Does your February budget suggest that additional workers will be needed? Assuming the wage rate is $20 per hour, how many additional labor hours are indicated for February? 5) What was the actual production cost per unit for the January? What is the expected production cost for February? Explain WHY the total production cost per unit changed in the direction that it did. 6) What is the “formula” that you could use to determine the total production cost for ALASKA for any particular month? 7) What formula could you use to determine the profit for any particular month? What is the anticipated profit for February? (Assume that there are no other expenses other than those mentioned above.) 8) What is the “formula” that you could use to determine the total production cost for ALASKA for the year? 9) Prepare a graph which shows ALASKA’s monthly production costs. Show $(cost) on the Y axis and PRODUCTION on the x axis. The graph should separately show: variable costs, fixed cost and total cost. Include points for BOTH January (actual) and February (budgeted). You may do this graph BY HAND and it need NOT be “to scale”.

Solutions

Expert Solution

Alaska Manufacturing
1) Prime cost of January
Direct Material $    50,000.00
Direct Labor $    20,000.00
Total Prime cost=($50000+$20000) $    70,000.00
Actual Production in January 20000 Widgets
Prime cost per unit=($70000/20000) $               3.50 Per Unit
Note: Prime cost of production includes Direct Material and labor cost excluding fixed cost
2) Conversion Cost
Direct Labor cost(Variable) $    20,000.00
Factory Rent(Fixed) $    12,000.00
Equipment Depreciation(Fixed) $    16,000.00
Other Production Cost(Fixed) $      2,000.00
Total Conversion cost $    50,000.00
Actual Production in January 20000 Widgets
Conversion cost per unit=($50000/$20000) $               2.50 Per Unit
Note: Conversion cost includes both direct and indirect production cost that involves to convert direct material into finished goods.Examples are wages,Depreciation of plant & equipment,Rent etc.
Formula: Direct Labor+Manufacturing Overheads
or
Total Manufacturing cost- Direct Material cost
3) Direct Material cost=($50000/20000)*25000 $    62,500.00
Direct Labor cost=($20000/20000)*25000 $    25,000.00
Factory Rent(Fixed) $    12,000.00
Equipment Depreciation(Fixed) $    16,000.00
Other Production Cost(Fixed) $      2,000.00
Total Production Cost $ 117,500.00
4) If the wage Rate is $20 per Hours ,Hours used in January=($20000/$20)= 1000 Hours
Hours required for 25000 units=(1000/20000)*25000= 1250 Hours
Additional Hours Required in February=(1250-1000) 250 Hours
Yes ,250 additional Hours required in February.
5) Actual Production Cost for January=($100000/20000) $               5.00 Per Unit
Actual Production Cost for February=($117500/25000) $               4.70 Per Unit
Prodcution cost per unit will be less in case of February because fixed cost per unit will changes due to increase production but variable cost per unit will remains the same at all levels of production
6) Formula Use for total Production=Direct Material+Direct Labor+Manufacturing Overheads
Manufacturing Overheads includes cost incurred in the factory except Direct Material and Direct Labor
7) Profit=Revenue-Cost
Sales=(25000*$5) $ 125,000.00
Less: Cost $ 117,500.00
Profit=($125000-$117500) $      7,500.00

Related Solutions

Excel Assignment # 5 Spring Northern Illinois Manufacturing is preparing its budget for the coming year....
Excel Assignment # 5 Spring Northern Illinois Manufacturing is preparing its budget for the coming year. The first step is to plan for the first quarter of that coming year. Northern Illinois gathered the following information from its managers. Sales: Unit sates for November, prior year 112,500 Unit sales for December, prior year 102,200 Expected unit sales for January 113,400 Expected unit sales for February 112,500 Expected unit sales for March 116,700 Expected unit sales for April 125,000 Expected unit...
a widget manufacturing company makes big widgets and small widgets. Each widget must processed in a...
a widget manufacturing company makes big widgets and small widgets. Each widget must processed in a wood shop and in a paint shop. It takes 480 minutes of process time per work day per shop. If the paint shop paints only small widgets, then 60 can be painted per day. If the paint shop paints large widgets only then 40 can be painted per day. If the wood shop only process large widgets only then it could process 50 widgets...
explain meaning of the budget, the reason for preparing the budget, the period for which the...
explain meaning of the budget, the reason for preparing the budget, the period for which the budgets are prepared, along with the justification of why the budget is important for these budget sales budget, cost of production budget, cash budget, purchade budget
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...
5. ABC Company is preparing their master budget and is preparing a schedule of expected cash...
5. ABC Company is preparing their master budget and is preparing a schedule of expected cash collections from sales for the first quarter of 2019. They expect sales in January to be $400,000, February to be $300,000, and March to be $500,000. !0% of the sales will be paid for in cash. The remainder will be charged on account. From past experience, the company knows their customers take 3 months to pay their bills in total, with 40% of a...
A manufacturing business makes and sells widgets. Each widget requires two units of raw materials, which...
A manufacturing business makes and sells widgets. Each widget requires two units of raw materials, which cost $3 each. Production and sales quantities of widgets each month are as follows: Month Sales and production units December (actual) 50,000 January (budget) 55,000 February (budget) 60,000 March (budget) 65,000 In the past, the business has maintained its inventories of raw materials at 100,000 units. However, it plans to increase raw material inventories to 110,000 units at the end of January and 120,000...
A manufacturing business makes and sells widgets. Each widget requires two units of raw materials which...
A manufacturing business makes and sells widgets. Each widget requires two units of raw materials which costs $3.00 each. Production and sales quantities of widgets each month are as follows: Month Sales and Production December (Actual) 50,000 units January (Budget) 55,000 units February (Budget) 60,000 units March (Budget) 65,000 units In the past the business has maintained its inventories of raw materials at 100,000 units. However, it plans to increase raw materials inventories to 110,000 units at the end of...
In preparing an operating budget, the sales budget is prepared first. Which of the following is...
In preparing an operating budget, the sales budget is prepared first. Which of the following is prepared next?
Q 1       A MANUFACTURING FIRM PRODUCES LEFT AND RIGHT WIDGETS. THE LEFT WIDGET FREQUENCY DISTRIBUTION...
Q 1       A MANUFACTURING FIRM PRODUCES LEFT AND RIGHT WIDGETS. THE LEFT WIDGET FREQUENCY DISTRIBUTION IS SHOWN HEREIN, AS IS THE RIGHT WIDGET FREQUENCY DISTRIBITON IS ALSO INCLUDED.                                                                                                                    CLASSES ARE PROVIDED, FREQENCIES ARE SHOWN , SOLVE EACH FOR THE FOLLOWING: MEAN, MEDIAN CLASS, MODAL CLASS, POPULATION AND SAMPLE STANDARD DEVIATIONS....
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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT