(Solved): How should i insert the data into the model and how to create a single one-way data table and a sing ...

You are contemplating the establishment of a small artisanal coffee roasting business, and need to determine how many coffee roasting machines you should have. A roasting machine has a maximum capacity of 10,000 pounds of coffee per year and costs $\$5,000$ to rent per year. The lease for renting the machines can be renewed or cancelled in 1 year, and includes all maintenance costs. Raw coffee beans are your only ingredient and cost $\$3.00$ per pound. Additionally, it costs approximately $\$5.00$ to roast and package a pound of coffee. Other fixed costs (including marketing, utilities, and administrative expenses) will add up to $\$3,500$ per month. You plan to charge $\$15.00$ per pound to your customers, but you're also interested in how different selling prices could change your profits. However, the demand for your specialty coffee in the local market is uncertain. Your preliminary research suggests that the annual demand could range from 5,000 to 30,000 pounds. However, you will only produce as much roasted coffee as needed to meet demand. In this assignment, you will build a model to determine how many roasting machines to rent and at what price to sell your coffee, in order to maximize your profit for the year. Sensitivity Analysis with Datatables Suppose that you've decided to sell the roasted coffee at $\$15/$ pound. Use this as the selling price for the remaining questions. Create data tables in your Excel model to answer the following questions. You should only need a single one-way data table and a single two-way data table. Question 7 If you rent 4 roasting machines, what is the lowest level of demand needed to beak even? \begin{tabular}{l} \hline, 000 \\ \hline 10,000 \\ \hline 15,000 \\ \hline 20,000 \\ \hline 25,000 \end{tabular} If you think demand will certainly be between 25,000 and 30,000 pounds, how many roasting machines should you rent to maximize profit? 1 2 3 4 5 Question 9 $1\mathrm{pts}$ What is the lowest that demand can be at which 3 roasting machines is optimal? \begin{tabular}{|l|} \hline 5,000 \\ \hline 10,000 \\ \hline 15,000 \\ \hline 20,000 \\ \hline 25,000 \\ \hline \end{tabular}