Question

You would like to construct an aggregate production plan for product X341 for the next four quarters. Cost of regular production 100 $/u Cost of overtime production 150 $u Inventory holding cost 15 S/u/qtr Cost of increasing production 120 $/u Cost of decreasing production 160 $/u Subcontracting cost 170 $/u Stockout cost 180 $/u Previous quarters regular output 1500 u Beginning inventory level-30 u The forecasted demand for the next four quarters are: 1000, 300, 600, and 900 units. Suppose that you want to use a chase strategy that increases and decreases production level to meet the quarter demand. You do not want to use any subcontract or overtime. Furthermore, you will keep inventory as low as possible. Stockouts are not allowed. You must perform the calculation and answer the questions shown below. NOTE: Do not use any comma in your answers. The regular production is decreased by The regular production is decreased by The regular production is increased by Total regular production is Total regular production cost is $ Total cost of increasing regular production is $ Total cost of decreasing regular production is $ Total cost of production is $ units in quarter 1. units in quarter 2 units in quarter 4 units
0 0
Add a comment Improve this question Transcribed image text
Request Professional Answer

Request Answer!

We need at least 10 more requests to produce the answer.

0 / 10 have requested this problem solution

The more requests, the faster the answer.

Request! (Login Required)


All students who have requested the answer will be notified once they are available.
Know the answer?
Add Answer to:
You would like to construct an aggregate production plan for product X341 for the next four...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Similar Homework Help Questions
  • You would like to construct an aggregate production plan for product X341 for the next four...

    You would like to construct an aggregate production plan for product X341 for the next four quarters. Cost of regular production = 60 $/u Cost of overtime production = 90 $/u Inventory holding cost = 10 $/u/qtr Cost of increasing production = 70 $/u Cost of decreasing production = 120 $/u Subcontracting cost = 115 $/u Stockout cost = 130 $/u Previous quarter's regular output = 225 u Beginning inventory level = 25 u The forecasted demand for the next...

  • You would like to construct an aggregate production plan for four quarters of 2021. Product name:...

    You would like to construct an aggregate production plan for four quarters of 2021. Product name: TRX3010 Cost of regular production = 50 $/u Cost of overtime production = 65 $/u Inventory holding cost = 5 $/u/qtr Cost of increasing production = 40 $/u Cost of decreasing production = 45 $/u Previous quarter's regular production = Beginning inventory level = 250 u 4200 u The forecasted demand for the next four quarters is 3700, 4000, 2600, and 3900 units. You...

  • Answer Part B using excel and show equations that were used. explain if the problem is...

    Answer Part B using excel and show equations that were used. explain if the problem is suffiecent or not. You would like to construct an aggregate production plan for four quarters of 2021. Product name: TRX3010 Cost of regular production = 50 $/u Cost of overtime production = 65 $/u Inventory holding cost = 5 $/u/qtr Cost of increasing production = 40 $/u Cost of decreasing production = 45 $/u Previous quarter's regular production = 4200 u Beginning inventory level...

  • Given the following demand forecasts, costs, and constraints for a company. Regular Prod. Capacity = 27,000...

    Given the following demand forecasts, costs, and constraints for a company. Regular Prod. Capacity = 27,000 units/qtr Regular Prod. Cost = $12/unit Overtime Prod. Capacity = 3000 units/qtr Overtime Prod. Cost = $20/unit Subcontracting Capacity = 16,000 units/qtr Subcontracting Cost = $25/unit Inventory Capacity = 32,000 units/qtr Inventory Cost = $5/unit/qtr Beginning Inventory = 0 Backorder Cost = $15/unit/qtr Quarter Demand (units) 1 19,200 2 42,000 3 27,000 4 10,800 What is the cost if the company uses level production...

  • The owner of a small mill-working plant that builds cabinets is developing his aggregate plan for...

    The owner of a small mill-working plant that builds cabinets is developing his aggregate plan for the next year. The relevant cost data and forecast for the next 4 quarters is provided below. The company currently has 20 employees and works one 8 hour shift each day with 2 paid 15 minute breaks. Assume each quarter has 65 working days, and that it currently has no units in stock. Use this information and the information from the table to answer...

  • Her operations manager is considering a new plan, which begins in January with 200 units on hand and ends with zero inv...

    Her operations manager is considering a new plan, which begins in January with 200 units on hand and ends with zero inventory. Stockout cost of lost sales is $125 per unit. Inventory holding cost is $20 per unit per month. Ignore any idle-time costs. The plan is called plan B. Plan B: Produce at a constant rate of 1,400 units per month, which will meet minimum demands. Then use subcontracting, with additional units at a premium price of $75 per...

  • A small manufacturer of specialty welding equipment has developed a level production plan for the next...

    A small manufacturer of specialty welding equipment has developed a level production plan for the next four quarters, as seen below: Supply/Demand Info Pre-Q1   Q1 Q2 Q3 Q4    Forecast (demand) 2,300 2,760 3,680 5,980 Regular production 3,680 3,680 3,680 3,680 Subcontract production Ending inventory Hired employees 11 Fired employees Total employees 21 32 32 32 32 The table below shows additional relevant information: Capacity Information & Cost Variables    Production rate (units/employee/quarter) 115 Subcontractor capacity (units/quarter) 480 Regular production...

  • 02 Consuelo Chua, Inc., is a disk drive manufacturer in need of an aggregate plan for...

    02 Consuelo Chua, Inc., is a disk drive manufacturer in need of an aggregate plan for July through December. The com- pany has gathered the following data: COSTS Holding cost $8/disk/month Subcontracting 580/disk Regular-time labor $12 hour Overtime labor $18 hour for hours above 8 hours/workerday Hiring cost $4000/ worker Layoff cost $8000/worker DEMAND Note: In this problem (and Q3) the production cost should be computed based on the labor cost OTHER DATA Current worden 8 people Labor hours disk...

  • A disk drive manufacturer is in need of an aggregate plan for July to December. The...

    A disk drive manufacturer is in need of an aggregate plan for July to December. The company has gathered the following data: Month Demand Month Demand July 400 Oct 700 Aug 500 Nov 800 Sep 550 Dec 700 Item Cost Materials $35/disk Inventory $8/disk/month Subcontracting $80/disk Stock-out $15/disk Regular time labor $12/hour Overtime labor $18/hour (above 8 hrs) Hiring cost $40/worker Layoff cost $80/worker Other data include: Item Data Current workforce (June) 8 people Labor hours per disk 4 hrs...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT