Upload Assignment: Problem $1.$

Student Dashboard

Chapter $16$: Summary and Case...

Search results $-$ towe$03$@nsuo

Chapter $16$: Problems

$($KFID$).$

Required

a$.$ Download the spreadsheet from the course website and complete it by creating formulas to calculate:

i$.$ Receiving capacity

ii$.$ Cost per pallet received $($Note: standard cost equals total costs divided by maximum capacity$)$

iii. Cost of receiving capability used

iv$.$ Cost of unused receiving capability

b$.$ Acme now wishes to further downsize its operations under options $1$ and $2,$ but without impairing its ability to receive and process incoming shipments. Thus, it desires to keep enough employees to be able to process at least $2600$ pallets per day. Management realizes it cannot employ a fraction of a worker, thus there will continue to be some excess capacity with both options.

Complete the remainder of the spreadsheet to show:

i$.$ Number of employees required under all three options

ii$.$ Actual receiving capability under all three options

iii. Cost per pallet received $($Note: standard cost equals total costs