please answer the rows 29,30, and 31 statements. REQUIRED

1. Download the spreadsheet from Moodle and complete it by creating formulas to calculate
   1. Receiving capacity
   2. Cost per pallet received (Note: standard cost equals total costs divided by maximum capacity)
   3. Cost of receiving capability used
   4. Cost of unused receiving capability

1. ABC 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 that 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

1. Number of employees required under all 3 options
2. Actual receiving capability under all 3 options
3. Cost per pallet received (Note: standard cost equals total costs divided by maximum capacity)
4. Cost of receiving capability used
5. Cost of unused receiving capability