Management has decided to reduce direct material and ordering costs by purchasing sub-assembled components and not...

Management has decided to reduce direct material and ordering costs by purchasing sub-assembled components and not individual parts. you must do the following.

Current						Changes
Manufacturing costs Information for 100,000 units						Revised Manufacturing costs Information for 100,000 units
Cost Category	Cost Driver	Cost Driver Qty	Budget units per cost driver	Budget Total Qty	Budgeted cost per unit	Budget cost driver QTY	Budget units per cost driver	Budget Total Qty	Budgeted Cost per unit of Cost Driver	Revised Total
Direct Material	Number of kits	1	100,000	100,000	180	?????	?????	?????	?????	?????
Direct Labor	Direct Labor hours	3	100,000	300,000	30	?????	?????	?????	?????	?????
Direct Machine	Machine-Hours	0	0	150,000	25	?????	?????	?????	?????	?????
Ordering and Receiving	Number of orders	100	100	10,000	40	?????	?????	?????	?????	?????
Test and inspection	Testing hours	15	100,000	1,500,000	2	?????	?????	?????	?????	?????
Rework	Rework	2	5,000	10,000	20	?????	?????	?????	?????	?????

	Revised Manufacturing costs for 100,000 units	Costs per 100,000
Direct Manufacutring Costs
Direct Material Costs
Direct Labor Costs
Direct Machine costs
Direct Manufacturing costs
subtotal

Manufacturing Overhead costs:
Ordering and receiving costs
Testing and inspection costs
Rework costs
Manufacturing Overhead Costs
Total Costs

Requirements:

Using the Revised Category Costs tab, make the following changes under " Changes" Category. Other categories' costs remain same.
- Reduce direct labor rate from $30.00 to $28.00 per unit
- Reduce direct labor quantity from 3.00 to 2.65 hours per unit
- Reduce receiving and shipping ordering quantity from 100 to 90 units.
- Reduce testing and inspection from $2.00 to $1.75 per unit
- Reduce rework costs from $20 to $18 per unit
- Compute total costs for each category
- Complete Revised Cost Information tab
- Calculate total costs
- Calculate cost per unit for each category, round to two decimal points

Show all calculations within the cells. This means that you must use formulas and links so that your thought process can be examined. You must also include a detailed explanation of each journal entry that you make or do not make on each date to convey your thought process.

Expert Solution

Cost Category	Budget cost driver QTY	Budget units per cost driver	Budget total quantity	Budgeted cost per unit of cost driver	Revised Total
							(A)	(B)	(C)	(D)	(E)
									(A x B)		(C x E)
						Direct Material	1	100000	100000	180	18000000
Direct Labor	2.65	100000	265000	30	7950000
Direct machine	0	0	150000	25	3750000
Orderign and Receiving	90	100	9000	40	360000
Test and inspection	15	100000	1500000	1.75	2625000
Rework	2	5000	10000	18	180000
Total Cost					32865000

	Revised manufacturing cost for 100,000 units	Cost per unit
			Direct Material	18000000	180.00
Direct Labor	7950000	79.50
Direct machine	3750000	37.50
Orderign and Receiving	360000	3.60
Test and inspection	2625000	26.25
Rework	180000	1.80
Total Cost	32865000	328.65

ekkarill92 answered 1 year ago

Six categories of costs associated with inventories are purchasing costs, ordering costs, carrying costs, stock out...

Six categories of costs associated with inventories are purchasing costs, ordering costs, carrying costs, stock out costs, quality costs, and shrinkage. Assume you are seasoned manager training new employees about the importance of inventory management. In 200 words or more, describe at least two of these inventory costs. Include specific examples in order to effectively explain these concepts.

Costs for Product Y Direct material $90 Direct labo

Costs for Product Y Direct material $90 Direct labor 45 Variable Factory Overhead 35 Variable Selling Costs 5 Fixed Factory Overhead* 30 Fixed Selling Costs* 10 Total Cost per unit $215 *Reflects common (allocated) costs that will not change with special order Capacity = 200,000 units, currently producing 120,000 units The normal selling price per unit = $250 The special order: A customer outside the normal market offers to purchase 60,000 units of Product Y. Variable...

The senior management at Brady Food Company Ltd. (BFC) has decided to acquire new automated ordering...

The senior management at Brady Food Company Ltd. (BFC) has decided to acquire new automated ordering kiosks for its 10 restaurants. Senior management is trying to decide whether it should purchase the kiosks with borrowed funds or lease the kiosks for a seven-year period. Leasing costs would be $150,000 per year with payments made at the beginning of each year. Under the lease agreement, BFC would be responsible for yearly maintenance costs of $28,500. Insurance costs are included in the...

Actual Direct labor costs and Actual Direct material costs are written [entered, or put] on A...

Actual Direct labor costs and Actual Direct material costs are written [entered, or put] on A job-order sheet. Estimated, not actual, manufacturing overhead costs are entered on a Job-order Sheet. A. Explain why estimated costs are used. B. Explain how the amount of manufacturing Overhead costs entered on a particular job-order cost sheet is determined.

Management has told you that they want to reduce total costs of operations and SG&A by...

Management has told you that they want to reduce total costs of operations and SG&A by 10%. What types of reports would you look at to make these decisions?

direct material (DM), direct labor (DL) and manufacturing overhead (MOH) are considered components of product cost...

direct material (DM), direct labor (DL) and manufacturing overhead (MOH) are considered components of product cost that eventually become part of inventory cost. Selling and administrative expenses are typically considered period costs that should be charged to expenses in the period in which those are incurred. Now, what happens if a period cost is incorrectly classified as a product cost, and vice versa? What is affected, and how does that matter? [think about where these costs eventually end up and...

7) If direct labor and direct material costs increase by $1 each, contribution margin ________. A)...

7) If direct labor and direct material costs increase by $1 each, contribution margin ________. A) increases by $20,000 B) increases by $14,000 C) decreases by $24,000 D) decreases by $14,000 Answer the following questions using the information below: Alex Furniture sells a table for $850. His fixed costs are $25,000, while his variable costs are $500 per table. He currently plans to sell 175 tables this month. 8) What is the budgeted revenue for the month assuming that Alex...

A company is considering purchasing equipment costing $ 92,000. The equipment is expected to reduce costs...

A company is considering purchasing equipment costing $ 92,000. The equipment is expected to reduce costs from year 1 to 3 by $22,000, year 4 to 9 by $9,000,and in year 10 by $2,000. In year 10, the equipment can be sold at a salvage value of $15,000. Calculate the internal rate of return (IRR) for this proposal.

Determine whether each of the following costs should be classified as: Direct material Direct Labor Manufacturing...

Determine whether each of the following costs should be classified as: Direct material Direct Labor Manufacturing Overhead Period Cost Oils, glues, resins Answer 1 The factory janitor's salary Answer 2 Frames and tires used in manufacturing bicycles Answer 3 Wages paid to the workers assembling the bicycles for sale Answer 4 Depreciation of office computer system Answer 5 Wood purchased to manufacture tables made of wood. Answer 6 Depreciation on factory equipment Answer 7 The company spends $35,000 a year...

Mohkam’s incurred the following costs during 2019. Direct material used .......................................................................................... Rs.87,000,000 Direct labor .................................................................

Mohkam’s incurred the following costs during 2019. Direct material used .......................................................................................... Rs.87,000,000 Direct labor ....................................................................................................... 162,000,000 Manufacturing overhead applied ........................................................................ 90,000,000 During 20x2, products costing $600,000 were finished, and products costing $66,000,000 were sold on account for $97,500,000. There were no purchases of raw material during the year. The beginning balances in the firm’s inventory accounts are as follows: Raw material .................................................................................................... $113,500,000 Work in process ................................................................................................ 9,000,000 Finished goods ................................................................................................. 15,000,000 Required: 1. Prepare T-accounts to show the flow...

Question