PP.61 A small manufacturer of specialty welding equipment has developed a level production plan for the...
PP.61 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) | 4,600 | 4,600 | 3,680 | 6,440 | |
| Regular production | 4,830 | 4,830 | 4,830 | 4,830 | |
| Subcontract production | |||||
| Ending inventory | |||||
| Hired employees | 12 | ||||
| Fired employees | |||||
| Total employees | 30 | 42 | 42 | 42 | 42 |
Additional Information:
| Capacity Information & Cost Variables | |
| Production rate (units/employee/quarter) | 115 |
| Subcontractor capacity (units/quarter) | 480 |
| Regular production cost/unit | $70 |
| Holding cost/unit/quarter | $14 |
| Hiring cost/employee | $980 |
| Firing cost/employee | $2,600 |
| Subcontract cost/unit | $105 |
What is the overall total cost for this production plan? (Display your answer to the nearest whole number.)
What is the total regular production cost for this production plan? (Display your answer to the nearest whole number.)
What is the total holding cost for this production plan? (Display your answer to the nearest whole number.)
What is the total hire cost for this production plan? (Display your answer to the nearest whole number.)
What is the total fire cost for this production
plan? (Display your answer to the nearest whole
number.)
PLEASE DISPLAY ANSWERS IN EXCEL
Homework Answers
Below is the desired production schedule -
| Pre - Q1 | Q1 | Q2 | Q3 | Q4 | Total | Cost per unit | Cost | |
| Beginning Inventory | 0 | 230 | 460 | 1610 | ||||
| Forecast (Demand) | 4600 | 4600 | 3680 | 6440 | ||||
| Regular Production | 4830 | 4830 | 4830 | 4830 | 19320 | 70 | 1352400 | |
| Subcontract Production | 0 | 0 | 0 | 0 | 0 | 105 | 0 | |
| Ending Inventory | 0 | 230 | 460 | 1610 | 0 | 2300 | 14 | 32200 |
| Hired Employees | 12 | 0 | 0 | 0 | 12 | 980 | 11760 | |
| Fired Employees | 0 | 0 | 0 | 0 | 0 | 2600 | 0 | |
| Total Employees | 30 | 42 | 42 | 42 | 42 | |||
| Total Cost | 1396360 |
What is the overall total cost for this production plan - 1396360
What is the total regular production cost for this production plan - 1352400
What is the total holding cost for this production plan - 32200
What is the total hire cost for this production plan - 11760
What is the total fire cost for this production plan - 0
Below is the screenshot of the formula applied -
Add Answer to:
PP.61 A small manufacturer of specialty welding equipment has
developed a level production plan for the...
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...
PP.72 A manufacturer of solid state drives (SSDs) has projected the next six months of demand...
PP.72 A manufacturer of solid state drives (SSDs) has projected the next six months of demand to be as shown the table below: Supply/Demand Info Beginning Jan Feb Mar Apr May Jun Forecast (demand) 48,000 52,000 60,000 54,000 58,000 64,000 Regular production Overtime production Subcontract production Ending inventory 6,000 Hired employees Fired employees Total employees 200 Cost variables as as follows: Cost Variables Labor cost/hour $14 Overtime cost/unit $32 Subcontracting cost/unit $29 Holding cost/unit/month $8 Hiring cost/employee $2,500 Firing cost/employee...
I only have 1 hour left, please help!! PP.62 A manufacturer of solid state drives (SSDs)...
I only have 1 hour left, please help!! PP.62 A manufacturer of solid state drives (SSDs) has projected the next six months of demand to be as shown the table below: Supply/Demand Info Beginning Jan Feb Mar Apr May Jun Forecast (demand) 48,000 52,000 60,000 54,000 58,000 64,000 Regular production Overtime production Subcontract production Ending inventory 6,000 Hired employees Fired employees Total employees 200 Cost variables as as follows: Cost Variables Labor cost/hour $14 Overtime cost/unit $32 Subcontracting cost/unit $29...
PP.63 Jupiter, a large candy company, is having great success with its "Swan" family of candy...
PP.63 Jupiter, a large candy company, is having great success with its "Swan" family of candy bars. Due to a number of factors they like to plan their production at least nine months into the future. The table below contains their demand projections (in tons) for April through December: Supply/Demand Info Beginning Apr May Jun Jul Aug Sep Oct Nov Dec Predicted sales 3,000 2,200 1,900 2,000 2,400 3,200 4,800 2,700 3,600 Regular production Overtime production Subcontract production Ending inventory...
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...
Jose Martinez of El Paso has developed a polished stainless steel tortilla machine that makes it...
Jose Martinez of El Paso has developed a polished stainless
steel tortilla machine that makes it a "showpiece" for display in
Mexican restaurants. His forecast of capacity and demand
follows:
Assume that back-orders are not permitted.
Using the transportation method, the total cost of the optimal
plan is $_______. (enter your response as a
whole number).
Month 2 150 140 130 220 230 Demand Capacity Regular time Overtime 140 140 150 10 150 10 30 20 Subcontracting: 100 units available...
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 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).
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).
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...
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...
Jose Martinez of El Paso has developed a polished stainless
steel tortilla machine that makes it a "showpiece" for display in
Mexican restaurants. His forecast of capacity and demand
follows:
Assume that back-orders are not permitted.
Using the transportation method, the total cost of the optimal
plan is $_______. (enter your response as a
whole number).
Month 2 150 140 130 220 230 Demand Capacity Regular time Overtime 140 140 150 10 150 10 30 20 Subcontracting: 100 units available...
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...
Most questions answered within 3 hours.
-
MATLAB HW 11 problem using Switch Case and Input commands
Write a script file that calculates...
asked 12 minutes ago -
A college student is employed as a door-to-door newspaper
salesman. Historical data suggests that the student...
asked 26 minutes ago -
Considering gravitational time dilation, calculate the time that
passes in Earth’s surface while 1 hour passes...
asked 50 minutes ago -
Minitab Problem: Take the Lake Hume June rainfall data and find
use the processes outlined in...
asked 1 hour ago -
X Company is trying to decide whether to continue using old
equipment to make Product A...
asked 1 hour ago -
IN PYTHON ONLY !! Program 2: Re-work
program #5 (WeeklyHours) from the previous assignment such that...
asked 2 hours ago -
The average length of time between arrivals at a turnpike
toll-booth is 26 seconds. What is...
asked 4 hours ago -
(a) A piston at 6.1 atm contains a gas that occupies a volume of
3.5 L....
asked 5 hours ago -
Please answer true or false. Words
cannot be changed or added in to make it true...
asked 5 hours ago -
An empty test tube weighs 15.923 grams. Then,
MgCl2•6H2O is added into the test tube. After...
asked 5 hours ago -
Assume memory access is 10 units of time and disk access is
10000 units of time....
asked 5 hours ago -
1. Are all good samples random?
2. Magazines often report surveys giving statistics such as “63%...
asked 5 hours ago