Please read instruction carefully along with the attachment.

profilewangjia7_01
inventory_order_form.xlsx
Home>Business & Finance homework help>Operations Management homework help>Please read instruction carefully along with the attachment.

Initial Order

Team Project Part 1 - New Par Inventory for complete Linen/Terry Upgrade
Linen Products Terry Products
Sheets Blanket Duvet Cover Pillow Cases Bath Towel Hand Towel Wash Cloth Bath Mat
1 Par Unit Count 1 Ea 1 Ea 1 Ea 4 Ea 4 Ea 4 Ea 4 Ea 1 Ea
In Service Inventory:
In Room 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0
On Cart 1.0 0.1 0.1 1.0 1.0 1.0 1.0 1.0
In Laundry 1.5 0.1 0.1 1.5 1.5 1.5 1.5 1.5
Total In Service 3.5 1.2 1.2 3.5 3.5 3.5 3.5 3.5
Inventory on Hand in Storage 1.0 0.1 0.2 1.0 1.0 1.0 1.0 1.0
Other Statistics:
Consumption rate Per Occupied Room 0.05 0.01 0.01 0.05 0.07 0.05 0.07 0.03
Delivery Time (in Days) 30 30 60 30 30 30 30 45
Order Quantity 20 10 5 20 100 100 100 30 Note: Your Order must be placed in multiples of these quantities
Unit Price $24.50 $73.25 $198.50 $12.25 $7.25 $3.15 $1.67 $15.30
Available Rooms 200
Average Monthly Occupancy % 85%
Initial Order Quantity Your answer here

Monlhly Order

Team Project Part 1 -Order Calculation for Monthly Order
Linen Products Terry Products
Sheets Blanket Duvet Cover Pillow Cases Bath Towel Hand Towel Wash Cloth Bath Mat
1 Par Unit Count 1 Ea 1 Ea 1 Ea 4 Ea 4 Ea 4 Ea 4 Ea 1 Ea
In Service Inventory:
In Room 200 200 200 400 400 400 400 100 This is assumed
On Cart 200 20 20 400 400 400 400 100 This is based on all carts completely stocked
In Laundry 235 10 7 200 485 501 332 104 This was physically counted
Total In Service 635 230 227 1000 1285 1301 1132 304
Inventory on Hand in Storage 25 5 10 200 128 116 245 75 This was physically counted
Other Statistics:
Consumption rate Per Occupied Room 0.05 0.01 0.01 0.05 0.07 0.05 0.07 0.03
Delivery Time (in Days) 30 30 60 30 30 30 30 45
Order Quantity (units per case) 20 10 5 20 100 100 100 30 Note: Your Order must be placed in multiples of these quantities
Unit Price $24.50 $73.25 $198.50 $12.25 $7.25 $3.15 $1.67 $15.30
Available Rooms 200
Average Monthly Occupancy % 85%
Initial Order Quantity Your answer here
Physical Ending Inventory
- Required Par
= Base Order Quantity
Base Order Quantity
+ Consumption during Delivery Time
= Standard Order Quanity
Standard Order Quantity
Divided by Units Per Case
= Case Order Quantity
Cost Per Case
Cost of Order Placed Your Answer Here