Bargainmart is an international retail store. Bargainmart's managers are considering implementing a new business$-$to$-$business $($B$2$B$)$ information system for processing merchandise orders. The current system costs Bargainmart $$1,000,000$ per month and $$55$ per order. Bargainmart has two options, a partially automated B$2$B and a fully automated B$2$B system. The partially automated B$2$B system will have a fixed cost of $$6,000,000$ per month and a variable cost of $$45$ per order. The fully automated B$2$B system has a fixed cost of $$13,200,000$ per month and a variable cost of $$30$ per order. Based on data from the past $2$ years, Bargainmart has determined the following distribution on monthly orders:

$($Click the icon to view the data.$)$

Read the requirements.

Requirements $1$ & $2.$ Prepare a table showing the cost of each plan for each quantity of monthly orders. What is the expected cost of each plan?

Determine the monthly cost of each order level under the current plan and then compute the expected cost.

Current plan

$\backslash$table$[[$Order level,$\backslash$table$[[$Total monthly cost$],[$of orders$]]\{$f$58$fd$64$e$8-44$fb$-4$cab$-$adae$-34$c$0$e$6853$a$6$d$\}$ Probability,$=,\backslash$table$[[$Total expected$],[$cost of orders$]]],[300,000$ orders,$,=,],[500,000$ orders,$,=,],[700,000$ orders,$,=,],[$Total expected cost of plan,,,$]]$

Prepare a table showing the cost of each plan for each quantity of monthly orders.

What is the expected cost of each plan?

In addition to the information systemf; costs, what other factors should Bargainmart consider before deciding to implement a new B$2$B system?

$\backslash$table$[[$Monthly Number of Orders,Probability$],[300,000$ orders,$0\mathrm{.}10],[500,000$ orders,$0\mathrm{.}30],[700,000$ orders,$0\mathrm{.}45]]$