Background:

Wes and Steve are partners in a lunch truck company that operates a central kitchen and operates lunch trucks that travel to various locations in Philadelphia, Monday-Friday. The lunch trucks deliver pre-packaged healthy sandwich and salad alternatives, fresh fruit and pre-packaged low-fat desserts and canned beverages. Together, the partners have to make many decisions about how to structure the operational aspects of the business so that it is cost effective, efficient and profitable.

Current Situation:

Wes and Steve have begun to sell their bottled hot sauce to area markets.They have prepared a forecast of expected demand for the bottles for the next 6 periods as shown below. Given this information and the data re: capacities and costs, complete the 2 required aggregate plans on the next pages and answer the Qs shown.

Period	1	2	3	4	5	6	Total
Forecast	200	100	600	300	400	200	1,800

Maximum regular production = 200 units/period

Maximum overtime = 75 units/period

Maximum Subcontracting = 500/period

Beginning inventory = 0

Regular time cost = $10

Overtime cost = $15

Sub-contract cost = $25

Inventory holding costs are $1/average unit/period

Backorders cost of $20/unit/period

Important Notes:

• You must write neatly and NOT in red ink.
• You are not permitted to cross out answers; use white-out or start over.
• If I cannot read your work, you will receive zero points.
• CARRY THROUGH ERRORS COUNT and points will be deducted! Double check your work.

****** PLEASE SUBMIT ONLY PAGE 2 and 3FOR GRADING.*********

BUAD306 - Murphy Fall 2022 - Sec 14 LAST NAME________________________ FIRST: __________________

Worksheet 7 - Agg Planning (15 pts) Due Fri, 11/18 at 6pm EST

Instructions: Print this and next page, reproduce by hand or complete via computer. Complete each of the plans and provide answers on the next page on the line provided ONLY.

When completed: Take a photo of THIS AND NEXT PAGE ONLYsave file and upload via the corresponding Assignment link in Canvas by the due date. Remember: No .HEIC files are permitted.

LEVEL PLAN (5 pts)

Periods	1	2	3	4	5	6	TOTAL
Forecast	200	100	600	300	400	200	1,800
Output
Regular
Overtime
Subcontract
Output - Forecast
Inventory
Beginning
Ending
Average
Backlog
Costs:
Output: Regular
Overtime
Subcontract
Inventory
Back orders
Total

Continue to Next Page

CHASE PLAN (5 pts)

Period	1	2	3	4	5	6	TOTAL
Forecast	200	100	600	300	400	200	1,800
Output
Regular
Overtime
Subcontract
Output - Forecast
Inventory
Beginning
Ending
Average
Backlog
Costs:
Output: Regular
Overtime
Subcontract
Inventory
Back orders
Total

1. Which plan is better from a cost standpoint? __________________________________________ (1 pt)
2. Which plan is better for employees? Why? _________________________________________________ (1 pt)
3. For both plans, might quality be jeopardized? Why?

________________________________________________________________________________________ (1 pt)

1. If demand was to increase over time, what STRATEGIC action must Wes and Steve undertake to ensure profitability, cost effectiveness and quality for their business? (FYI - there is only one correct answer to this Q.)

______________________________________________________________________(2 pts)