Question: Please help with steps to complete this:) Red Bluff Golf Course & Pro Shop Forecast of Product Sales begin{tabular}{c|c|c|c|} hline & A & B &



Red Bluff Golf Course \& Pro Shop Forecast of Product Sales \begin{tabular}{c|c|c|c|} \hline & A & B & C \\ \hline 1 & Red Bluff Golf Course 8 Pro Shop \\ \hline 2 & \multicolumn{3}{|c|}{ Profit Scenarios } \\ \hline 3 & Revenue & & \\ \hline 4 & & Retail Sales & $65,000.00 \\ \hline 5 & Golf Lessons and Fees & $220,000.00 \\ \hline 6 & Gross Revenue & $285,000.00 \\ \hline \end{tabular} Expenses Fixed Costs \begin{tabular}{c|c|c} \hline & A & B \\ \hline 1 & Red Bluff Golf Course \& Pro Shop \end{tabular} Solver for Golf Lessons \begin{tabular}{l|l} 2 & \\ \hline 3 & Input Variables \end{tabular} \begin{tabular}{l|r|} \hline Total Clients & 1 \\ \hline Instructors on Duty & 1 \\ \hline \end{tabular} \begin{tabular}{|l|l} \hline 4 & Total Clients \\ \hline 5 & Instructors on Duty \\ \hline \end{tabular} 6 Revenue \begin{tabular}{|l|r|} \hline Lesson Fee & $190.00 \\ \hline Gross Revenue & $190.00 \\ \hline \end{tabular} Expenses 10 Fixed Costs \begin{tabular}{|l|l|} \hline 11 & \\ \hline 12 & \\ \hline 13 & \\ \hline 14 & Total Fixed Costs \\ \hline 15 & Variable Costs \\ \hline \end{tabular} \begin{tabular}{|l|r|} \hline Utilities & $469.70 \\ \hline Equipment Depreciation & $1,234.20 \\ \hline Insurance & $360.80 \\ \hline & $2,064.70 \\ \hline \end{tabular} 15 Variable Costs \begin{tabular}{|l|l|} \hline 16 & \\ \hline 17 & \\ \hline 18 & Total Variable Costs \\ \hline 19 & Total Expenses \end{tabular} Instructor Commission Supplies per Client Total Expenses Net Income \begin{tabular}{|r|r|} \hline 10% & $19.00 \\ \hline$14.95 & $14.95 \\ \hline & $33.95 \\ \hline & $2,098.65 \\ \hline & $1,908.65 \\ \hline \end{tabular} Saved Solver Models
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
