A manufacturing firm uses a level utilization production-planning horizon of three months. They have developed a forecast for the coming three quarters that appears in the table
They can add no more than 10% of their production capacity as overtime and can order no more than 10% of a month's regular capacity via subcontractors. The company has a zero backorder policy but has space for a maximum of 100 items in their finished-goods inventory. If all extra costs are shown in the table, what is the minimum cost sales and operations plan?
January February March
Forecasted Demand 1100 950 1350
Regular Capacity 1000 1000 1000
Workforce level
Overtime ($40/unit)
Subcontracting ($100/unit)
Inventory holding ($10/unit)
Total Cost
Quantities appear in the upper section of the spreadsheet; costs are totaled at the bottom of each column.
January February March
Forecasted Demand 1100 950 1350
Regular Capacity 1000 1000 1000
Workforce level 1000 1000 1000
Overtime ($40/unit) 100 95 135
Subcontracting ($100/unit) 0 0 70
Inventory holding ($10/unit) 0 145 0
Total Cost 4000 5250 12400
You might also like to view...
The final step in the process of creating the master budget is the preparation of the ________
A) operating budget B) budgeted balance sheet C) budgeted statement of cash flows D) cash budget
And buyer has a proposed monthly mortgage payment of $1,300, a monthly car payment of $350, a monthly student loan payment of $200, and a monthly income of $4,800. He is applying for a conventional loan that allows a 28% housing expense to income ratio with a 36% debit to income ratio. Which of the following is true?
A. Both housing expenses and debit to income ratios are acceptable B. Housing expenses to income ratio is acceptable, but debit to income ratio is not acceptable C. Debit to income ratio is acceptable, but housing expenses to income ratio is not acceptable D. Neither housing expenses nor debit to income ratio is acceptable