Question: A company wants to develop a level production plan for a product in the coming five months, based on the data shown in Excel file.

A company wants to develop a level production plan for a product in the coming five months, based on the data shown in Excel file. If the opening inventory is 100 units and the ending inventory is 200 units, please figure out the level production plan for each month, and upload your work.

Opening inventory	100		Total production
Ending inventory	200		Daily planned production
Month	1	2	3	4	5
Working days	23	20	15	22	20
Forecast Demand	145	135	100	110	110
Planned Production
Planned Inventory	100

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

A company wants to develop a level production plan for a product in the coming five months, based on the data shown in Excel file. If the opening inventory is 100 units and the ending inventory is...

Question 3 A company wants to develop a level production plan for a product in the coming four months, based on the following data. 1 3 4 Month Working Days Forecast Demand 25 120 2 20 180 23 170 22...

CLASS EXERCISE TOPIC: Materials Management 2.1. If the opening inventory is 400 units, demand is 900 units, and production is 700 units, what will be the ending inventory? 2.2. A company wants to...

please help me to solve this 5 questions Question 1 a) If the cost of direct material is 50%, direct labor is 10%, and overhead is 25% of sales, What will be the improvement in profit if cost of...

How to do 2.4 here: 16. Describe four conditions under which a firm would make-to-strok or make-to-onder 17. What information is necded to develop a make-to-stock production plan? 18. What are the...

A production line is to run at 1 0 0 0 units per month. Sales are forecast as shown in the following. Calculate the expected period - end inventory. The opening inventory is 6 0 0 units. All periods...

Smart Manufacturing Company (SMC) manufactures a variety of products other than the drum components fo printers. Their high selling mobile juicer cup JG-142 has the following expected demand sales...

2.6. A production line is to run at 1000 units per month. Sales are forecast as shown in the following. Calculate the expected period-end inventory. The opening inventory is 600 units. All periods...

Please help! Show equations in Excel. 2.18. For the following data, calculate the number of workers required for level proudu tion and the resulting month-end inventories. Each worker can produce 9...

2 . 8 . A company wants to develop a level production plan for a family of products. The open - ing inventory is 5 5 0 units, and a decrease to 2 0 0 units is expected by the end of the plan. The...

How does a stock dividend differ from other types of dividends?

Giorgio Maggiali was becoming increasingly frustrated. As director of logistics for the world's largest pasta producer. Barilla SpA (Societe per Aziont translates as "Society for Stockholders" and is...

11. Wang Distributors, a wholesale firm, made sales using the following list prices and trade discounts. What amount should be recorded for each sale? 1. List price of $8,000 and trade discounts of...

Create a C# application named SalesTransactionDemo that declares several SalesTransaction objects and displays their values and their sum. The SalesTransaction class contains the following fields:...