A furniture workshop make $2$ models of tables: Office Table and Classroom Table. The Bill of Material $($BOM$)$ for these two products are in the attached Excel file.

Also there is a price list for all the items, whether purchase item from vendor or manufactured item.

You should be able to answer below questions.

Please submit your answers to each question clearly on the first page of your submission. The answer to each question should be very short, a number or few words.

Put your calculations and explanations on the next pages. I will mark based on your logic$/$ calculation$/$ explanation, not just the

Inventroy in Mfg$.$xlsx

results.

$1-$ If our annual demand is for $2500$ Office Table and $1500$ Class tables, how much dollars we will spend on ram material in a year?

$2-$ If we want to keep $2$ weeks of demand as safety stock, is it cheaper to keep as raw material or finished goods?

$3-$ How much would be the value of safety stock for two weeks?

$4-$ The vendor for table legs says the minimum order quantity is $300$ legs. $($We need to buy $300$ legs each time$).$ How long will it take for us to use this $300?$BOM for item TBL$0011-$ If our annual demand is for $2500$ Office Table and $1500$ Class tables, how much dollars we will spend on ram material in a year?

Category Item # Description Quantity Unit Item Unit Price $2-$ If we want to keep $2$ weeks of demand as safety stock, is it cheaper to keep as raw material or finished goods?

Manufacture TBL$001$ Office Table $1$ Each TOP$001503-$ How much would be the value of safety stock for two weeks?

LEG$001104-$ The vendor for table legs says the minimum order quantity is $300$ legs. $($We need to buy $300$ legs each time$).$ How long will it take for us to use this $300?$

Components SLT$0015$

Category Item # Description Quantity Unit SLT$00215$

Manufacture DRW$001$ Drawer $4$ Each NDL$0011$

Buy TOP$001$ Table Top $1$ Each TBL$001700$

Buy LEG$001$ Table Legs $4$ Each TBL$002500$

BOM for item TBL$002$

Category Item # Description Quantity Unit

Manufacture TBL$002$ Class Table $1$ Each

Components

Category Item # Description Quantity Unit

Manufacture DRW$001$ Drawer $2$ Each

Buy TOP$001$ Table Top $1$ Each

Buy LEG$001$ Table Legs $6$ Each

BOM for item DRW$001$

Category Item # Description Quantity Unit

Manufacture DRW$001$ Drawer $1$ Each

Components

Category Item # Description Quantity Unit

Buy SLT$001$ Wood Slat $3$ Foot

Buy SLT$002$ Wood Plate $2$ Sq Foot

Buy NDL$001$ Needles $2$ Ounce