PLEASE PROVIDE EXCEL FORMULA!!

Pristine Microware produces and sells different types of solid state hard drives, each varying in quality and storage capacity. Below is some information about its latest products. Silver (500 GB) Price Variable Cost Fixed Cost Projected Volume Price Variable Cost Fixed Cost Projected Volume Gold (1 TB) Platinum (2 TB) Price Variable Cost Fixed Cost Projected Volume $ $ $ $ $ $ 50 22 16,800 800 90 45 22,500 700 185 135 18,000 400 Required: Create a Contribution Format Income Statement for each of the solid state hard drives and calculate Breakeven Point, Margin of Safety, and Degree of Operating Leverage using the statements.

PLEASE PROVIDE EXCEL FORMULA!

PLEASE PROVIDE EXCEL FORMULA!

\begin{tabular}{|c|c|} \hline \multicolumn{2}{|l|}{ Silver (500 GB) } \\ \hline Sales & 40,000 \\ \hline Variable Cost & 17,600 \\ \hline Contribution Margin & 22,400 \\ \hline Fixed Cost & 16,800 \\ \hline Net Operating Income & 5,600 \\ \hline Breakeven Point (units) & 600 \\ \hline Breakeven Point (dollars) & 30,000 \\ \hline Margin of Safety (units) & 200 \\ \hline Margin of Safety (dollars) & 10,000 \\ \hline Margin of Safety (\%) & 2000000.0% \\ \hline Degree of Operating Leverage & 0.01 \\ \hline \multicolumn{2}{|l|}{ Gold (1 TB) } \\ \hline Sales & \\ \hline Variable Cost & \\ \hline Contribution Margin & \\ \hline Fixed Cost & \\ \hline Net Operating Income & \\ \hline Breakeven Point (units) & \\ \hline Breakeven Point (dollars) & r \\ \hline Margin of Safety (units) & \\ \hline Margin of Safety (dollars) & \\ \hline Margin of Safety (\%) & \\ \hline Degree of Operating Leverage & 1 \\ \hline \end{tabular} A B 81 Prove these numbers true by applying the change 82 83 Silver (500 GB) 84 Sales 85 Variable Cost 86 Contribution Margin 87 Fixed Cost 88 Net Operating Income 89 90 Gold (1 TB) 91 Sales 92 Variable Cost 93 Contribution Margin 94 Fixed Cost 95 Net Operating Income 96 97 Platinum (2 TB) 98 Sales 99 Variable Cost 100 Contribution Margin 101 Fixed Cost 102 Net Operating Income \begin{tabular}{l} Sales \\ Variable Cost \\ Contribution Margin \\ Fixed Cost \\ Net Operating Income \\ \hline Breakeven Point (units) \\ Breakeven Point (dollars) \\ Margin of Safety (units) \\ Margin of Safety (dollars) \\ Margin of Safety (\%) \\ Degree of Operating Leverage \end{tabular} Using the Degree of Operating Leverage only, fill in \begin{tabular}{l|c|} \hline \multicolumn{2}{|c|}{ Silver (500 GB) } \\ Projected Volume Increase & 10% \\ New Net Operating Income & \\ \hline \multicolumn{2}{|c|}{ Gold (1 TB) } \\ \hline Projected Volume Increase \\ New Net Operating Income \\ \hline \multicolumn{2}{|c|}{ Platinum (2 TB) } \\ \hline Projected Volume Increase & 10% \\ New Net Operating Income & 30% \\ \hline \end{tabular} Pristine Microware produces and sells different types of solid state hard drives, each varying in quality and storage capacity. Below is some information about its latest products. Required: Create a Contribution Format Income Statement for each of the solid state hard drives and calculate Breakeven Point, Margin of Safety, and Degree of Operating Leverage using the statements