OPER $3201,$ Assignment $2$a

Problem $1.$ Given the input data to S&OP plan, answer the following questions:

Use the following data for your spreadsheet:

$($a$)$ Convert the sales in million dollars to sales in labor hour $($in $000$s$)$

from Jan to Sep. $(1$pt$)$

$($b$)$ Find production in labor hour $($in $000$ s $)$ from Jan to Sep. $(1$pt$)$

$($c$)$ Find number of workers you need from Jan to Sep. $(1$pt$)$

$($d$)$ Find workers hired and fired from Jan to Sep. $(1$pt$)$

$($e$)$ Find beginning inventory, ending inventory, and backorders from Jan to

Sep. $(1$pt$)$

$($f$)$ Based on the spreadsheet, calculate the production cost, inventory

holding cost, firing cost, hiring cost, and backorder cost. $(2$pts$)-->$

Problem $1.$ Given the input data to S&OP plan, answer the following questions:

Use the following data for your spreadsheet:

Sales per labor hour $$20$

Hiring cost $ $300\mathrm{.}0$

Firing cost $ $500\mathrm{.}0$

Production cost per labor hour $ $15\mathrm{.}00$

Backorder cost per labor hour $$2$

Inventory carrying cost per labor hour $$1$

Number of Employees as of end of December $3000$

Employee Productivity $($in hours$/$day$)7$

$--->$

Beginning Ending Backorder

Sales

in

Production Inventory Inventor

y

Month Sales labor

hour

Working labor hour Number of Workers Workers labor

hour

labor

hour

labor

hour

$($Million$)(000$s$)$ days $(000$s$)$ Workers Hired Fired $(000$s$)(000$s$)(000$s$)$

$300013\mathrm{.}30$

January $820$

February $7\mathrm{.}421$

March $11\mathrm{.}223$

April $1220$

May $9\mathrm{.}822$

June $8\mathrm{.}522$

July $910$

August $11\mathrm{.}623$

September $9\mathrm{.}420$