ZuoTi.Pro
Question
needing help with solving in Excel

6. Given the following forecast and cost information, determine the total cost of a plan that uses regular time production ou

business   Operations-Management   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Aggregate plan based on proposed strategy, is following:

A B с Н. — ه G Average Inventory 1 Forecast Regular Max Overtime 50 570 600 WN 600 600 600 600 15 30 15 0 630 D E F Ending Ov

EXCEL FORMULA:

А B с D E F G H 1 1 Max Overtime 60 570 600 3 Month Forecast Regular Overtime Subcontract Ending Inventory Average Inventory

0 0
Add a comment
Know the answer?
Add Answer to:
needing help with solving in Excel 6. Given the following forecast and cost information, determine the...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • 11. (6 points) Calculate the correct answer. A manager would like to know the total cost...

    11. (6 points) Calculate the correct answer. A manager would like to know the total cost of a chase strategy that matches the forecast below using steady regular production rate of 200 units per month, a maximum of 20 units per month of overtime, and subcontracting as needed to make up any shortages. The unit costs are: Regular production- $25, Overtime $50, Subcontracting $70 Month Forecast 230 June July August September 240 October 250 November 240 What is the total...

  • A manager has projected demand for the next six months (below). Given this information, prepare a...

    A manager has projected demand for the next six months (below). Given this information, prepare a LEVEL aggregate plan for production. Assume maximum regular time production is 350 units per month. Overtime is limited to 75 units per month. The limit for subcontracting is 400 per month. The company has a zero beginning inventory and cannot have ending inventory or a backlog at the end of the 6th period. Unit costs are as noted below. Regular Time Cost: $10/unit Overtime...

  • 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...

  • Gang Aft Agley, a manufacturing company, faces the aggregate planning problem shown in the table below....

    Gang Aft Agley, a manufacturing company, faces the aggregate planning problem shown in the table below. Cost of regular production is $5 per unit, the cost of producing the same unit on overtime is $7.50, the cost of subcontracting is S9 per unit, an<d the cost of carrying a unit in inventory from one month to the next is $2 The labor contract at the plant prohibits overtime output to exceed 300 units in any five month window (that is...

  • Ram Roy's firm has developed the following supply, demand, cost, and inventory data Supply Available Regular...

    Ram Roy's firm has developed the following supply, demand, cost, and inventory data Supply Available Regular Time 30 30 40 Demand Period Overtime Subcontract Forecast 15 15 20 40 45 60 Initial inventory Regular-time cost per unit Overtime cost per unit Subcontract cost per unit Carrying cost per unit per month 20 units $100 $150 $200 $6 Assume that the initial inventory has no holding cost in the first period and backorders are not permitted Allocating production capacity to meet...

  • Ram​ Roy's firm has developed the following​ supply, demand,​cost, and inventory data

    Ram Roy's firm has developed the following supply, demand, cost, and inventory data.                                                                                                    Supply AvailablePeriodRegular TimeOvertimeSubcontractDemand Forecast140155402301556034015555Initial inventory20unitsRegular-time cost per unit$100Overtime cost per unit$160Subcontract cost per unit$250Carrying cost per unit per month$4Assume that the initial inventory has no holding cost in the first period and backorders are not permitted.Allocating production capacity to meet demand at a minimum cost using the transportation method, the total cost is$nothing(enter your response as a whole number).

  • Ram Roy’s firm has developed the following supply, demand, cost, and inventory data.

    Ram Roy’s firm has developed the following supply, demand, cost, and inventory data. Allocate production capacity to meet demand at a minimum cost using the transportation method. What is the cost? Assume that the initial inventory has no holding cost in the first period and backorders are not permitted.Initial Inventory 20 UnitsRegular Time cost per unit $100Overtime cost per unit $160Sub contract cost per unit $250Carrying cost per unit per month $6Supply TablePeriodRegular TimeOvertimeSubcontractDemand Forecast130155402301554534015555

  • The following forecast constitutes the demand for relay switches. John Smith, the production planner, has assembled...

    The following forecast constitutes the demand for relay switches. John Smith, the production planner, has assembled the following cost data and the quarterly demand forecast: QUARTER FORECAST 1,800 1 2 1,100 3 1,600 900 4 Costs/Other Data Previous quarter's output = 1300 cases Beginning inventory 350 cases Stockout cost = $110 per case Inventory holding cost $30 per case at the end of quarter Hiring employees = $40 per case Terminating employees = $75 per case Subcontracting cost = $60...

  • The total subcontracting costequals=​$ ???? ​(Enter your response as a whole​ number.) Total cost with plan...

    The total subcontracting costequals=​$ ???? ​(Enter your response as a whole​ number.) Total cost with plan 5​ = ???? Juarez has yet a sixth plan. A constant workforce of 7 is​ selected, with the remainder of demand filled by subcontracting. Evaluate this plan.The production rate per day equals= ???? A Juarez, Mexico, manufacturer of roofing supplies has developed monthly forecasts for a family of products. Data for the 6-month period January to June are presented in the table below. There...

  • Ram​ Roy's firm has developed the following​ supply, demand,​cost, and inventory data.

    Ram Roy's firm has developed the following supply, demand, cost, and inventory data.                                                                                                    Supply AvailablePeriodRegular TimeOvertimeSubcontractDemand Forecast130151040230151050330151045Initial inventory20unitsRegular-time cost per unit$100Overtime cost per unit$150Subcontract cost per unit$250Carrying cost per unit per month$4Assume that the initial inventory has no holding cost in the first period and backorders are not permitted.Allocating production capacity to meet demand at a minimum cost using the transportation method, the total cost is ____(enter your response as a whole number).

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