Can you help me fill this out through Excel?

The Orchard Beverage Company produces healthy alternatives to widely available soft drinks. Orchard makes its high-quality beverages with fresh fruit (bought at the peak of the season, when the fruit is juiciest, plentiful, and least expensive). These drinks are made with no preservatives in small batches. Over the company's first five years, sales have been brisk, with cases selling out well before forecasted. The owners of the company are considering rapid expansion of its production facilities, so that it can better respond to demand and possibly expand beyond its current regional sales territory. Before the company seriously considers expansion, the owners turn to you, the Orchard CFO/controller, to build a spreadsheet that will help owners better understand company profitability. Furthermore, considering the volatility of fruit prices, the owners also need to the ability to perform sensitivity analysis so that owners can try "what if" scenarios with respect to the price of fruit and the percentage of fruit used in each of its two products. Orchard's drink-ologists have experimented with blends and have found a certain mix can be used as a substitute in its drinks. A mix of fresh pear and grapefruit is used as a substitute when supplies of fresh lemons or limes are too few or too costly. For its Mixed Berries drink, Orchard uses a blend of grapes as a substitute when necessary. The results of taste tests suggest that few consumers will detect differences when cheaper ingredients are used, in moderation. The "classic" blend of Orchard's Citrus and Mixed Berries drinks are: Citrus: 48% Lemon, 48% Lime, 4% Pear/Grapefruit Blend Mixed Berries: 40\% Blueberry, 30\% Blackberry, 20\% Raspberry, 10\% Grape Blend Looking forward to next year, the sales team and you have developed following projections: Orchard Beverage operates in a state with no state income taxes and projects to be in the 25% Federal income tax bracket. For serious consideration of expansion, Orchard expects an after-tax profit of $1,500,000 is necessary to service the debt of a major expansion, should it decide to expand. Requirements: Prepare a spreadsheet using the model on the next page to meet the owners' needs. Answer the three questions that follow the model. \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|} \hline & Citrus & Mixed Berries & Total & & (Units = Cases) & Selling & Variable & & Contribution & \\ \hline Expected Sales (cases) & & & & & & Price & Cost/u & = & & \\ \hline Selling Price per case & & & & & Citrus & - & - & = & & \\ \hline Materials Cost per case (see below) & & & & & Mixed Berries & & - & = & - & \\ \hline Direct Labor per case & & & & & & & & & & \\ \hline Variable Overhead per case & & & & & Break-even per Pkg. & ixed Costs & - & 1 & \#DIV/0! & \\ \hline Fixed Costs & & & & & & & & & & \\ \hline Federal Income Tax Rate & & & & & & & & & & \\ \hline Direct Materials: (Standard Costs per & Quantity used & in the "Classic" & end) & & Desired After-Tax Pro & & & & & \\ \hline Citrus: & Standard Cost & Price Change % & Blend \% & Cost & & & & & & \\ \hline Lemon & $47.50 & & & - & Cases for Target Inc. & Pkg. = & - & 1 & \#DIV/0! & =# DIV /0! \\ \hline Lime & 55.00 & & & - & & & & & & \\ \hline Pear/Grapefruit Blend & 20.00 & & & - & & & & & & \\ \hline & & & tal & - & & & & & & \\ \hline Mixed Berries: & & & & & Proof: & Citrus & Mixed Berr. & & Total & \\ \hline Blueberry & 48.00 & & & - & Sales & \#DIV/0! & \#DIV/0! & & \#DIV/0! & \\ \hline Blackberry & 52.00 & & & - & Less: Variable Costs & \#DIV/0! & \#DIV/0! & & \#DIV/0! & \\ \hline Raspberry & 58.00 & & & - & Contribution Margin & #DIV/0 ! & \#DIV/0! & & #DIV/0 ! & \\ \hline Grape Blend & 16.00 & & & - & Less: Fixed Costs & & & & - & \\ \hline & & & tal & - & \begin{tabular}{l} Operating Income \\ Less: Income Tax \end{tabular} & & & & \begin{tabular}{l} \#DIV/0! \\ \#DIV/0! \end{tabular} & \\ \hline Input fields are grayed out. & & & & & Net Income after Tax & & & & \#DIV/0! & \\ \hline \end{tabular}