1. Prepare a table showing the cost of each plan for each quantity of monthly orders.
(Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab you will be marked wrong.)
Current plan
Order level	Monthly cost based on number of orders
300,000
500,000
700,000
Partially automated plan
Order level	Monthly cost based on number of orders
300,000
500,000
700,000
Fully automated plan
Order level	Monthly cost based on number of orders
300,000
500,000
700,000
2. What is the expected cost of each plan?
(Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab you will be marked wrong.)
Current plan
Partially automated plan
Fully automated plan

Please show work! such as =(C15*D15) for each cell.

Kindmart is an international retail store. Kindmart's managers are considering implementing a new business-to-business (B2B) information system for processing merchandise orders. The current svstem's costs include: Kindmart has two options, a partially automated B2B and a fully automated B2B system: \begin{tabular}{|l|c|c|} \hline & Fixed Costs per Month & Variable Cost per Order \\ \hline Partially automated B2B sytem & $6,000,000 & $45 \\ \hline Fully automated B2B system: & 14000000 & $25 \\ \hline \end{tabular} Based on data from the past two vears, Kindmart has determined the following distribution on monthly orders Use the blue shaded areas on the ENTERANSWERS tab for inputs. Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab you will be marked wrong