C268
Calculate the "Net Profit" part of the "Profit Summary" segment of the model by way of
subtracting the area charge from the income before the arena charge. - ANS-=C35-C36
Calculate the commissions paid for every product type. The commissions paid are calculated
because the predicted income for every product kind times the fee percent from the "Model
Inputs" phase of the model. - ANS-=C15*C5 (sales & commission %)
Calculate the fee of goods offered (COGS) for each product. The COGS is calculated as the
sales for every product type instances the COGS percent from the "Model Inputs" segment of
the version for that product type. - ANS-=C15*C4 (gross income * COGS %)
Calculate the gross profit for each product. The gross income is calculated because the income
minus the COGS for every product. - ANS-=C15-C16
Calculate the number of personnel that are had to paintings the occasion for every sort of
product. This is calculated because the earnings earlier than the arena rate for every kind of
product, instances the personnel (% of predicted income) for every product kind from the "Model
Inputs" section of the worksheet. Because you can't rent a fragment of an worker, round your
calculations up to the next complete number. - ANS-=ROUNDUP(C26*C7,zero)
(earnings earlier than arena * employees, 0 <- no decimals)
Calculate the profit earlier than the area charge for every product type. This is the gross profit
minus the full operating prices for each type of product, which include the salary costs (but to be
calculated). - ANS-=C17-C24
Calculate the income costs for each product type. This is calculated because the wide variety of
employees wished for every product type times the revenue (consistent with worker) inside the
"Model Inputs" phase. (Employees make the equal salary despite the product kind.) This will
create a circular reference on your worksheet. You will want to trade the alternatives in Excel to
accurately account for the round reference. - ANS-=C28*$C$eight
Calculate the entire working costs for each product type. This is the sum of salary charges (yet
to be calculated), commissions, and the fixed expenses for each product type. -
ANS-=SUM(C21:C23)
Complete the "Arena Fee" portion of the "Profit Summary" phase of the model via referencing
the area fee from the "Model Inputs" section of the worksheet. - ANS-=C9
, Complete the "Gross Profit" part of the "Profit Summary" section of the worksheet with the aid of
totaling the gross profit for all merchandise from the "Gross Profit" section of the version. -
ANS-=SUM(C17:E17)
Complete the "Profit earlier than Arena Fee" portion of the 'Profit Summary" section of the
worksheet through calculating the overall earnings earlier than the area rate for all products
from the "Operating Expenses" phase of the version. - ANS-=SUM(C26:E26)
Complete the "Sales" part of the "Profit Summary" phase of the worksheet by means of
calculating the full sales for all products from the "Gross Profit" section of the version. -
ANS-=SUM(C15:E15)
Complete the "Total Operating Expenses" part of the "Profit Summary" segment of the
worksheet by calculating the entire working expenses for all merchandise from the "Operating
Expenses" phase of the version. - ANS-=SUM(C24:E24)
Complete the data table inside the "What-if Analysis" section of the worksheet to examine the
internet profit for diverse values of the attendance forecast and the arena fee. - ANS-I22 = C37
(Net Profit)
Highlight all - I22:L29
Data-What If Analysis
Row = I13
Column = C9
Enter the fixed charges within the model. Reference the best quantity for every product type
within the "Model Inputs" phase. - ANS-=C6 (already referenced)
For most effective those activities with "Excellent" crowd sizes, how a whole lot overall products
revenue changed into earned? Select the answer closest to your solution from the drop-down
list in cellular J23. - ANS-$7Million
How likely is it that food income would exceed $220,000 if attendance is 18,000 human beings?
Select the correct solution from the drop-down list in mobile L35. - ANS-<five% chance
How lots more money from food sales has been generated at concert events than at other
events, now not such as sporting activities, for occasions in the sample? Select the solution
closest for your solution within the drop-down listing in cellular J31. - ANS-$625,000
In the "Event Profitability Analysis" section of the model, input the projected income for every
product type for this event with the aid of referencing your income forecast from the "Input
Analysis" segment of the version. - ANS-=I16 (calculated previously)
Calculate the "Net Profit" part of the "Profit Summary" segment of the model by way of
subtracting the area charge from the income before the arena charge. - ANS-=C35-C36
Calculate the commissions paid for every product type. The commissions paid are calculated
because the predicted income for every product kind times the fee percent from the "Model
Inputs" phase of the model. - ANS-=C15*C5 (sales & commission %)
Calculate the fee of goods offered (COGS) for each product. The COGS is calculated as the
sales for every product type instances the COGS percent from the "Model Inputs" segment of
the version for that product type. - ANS-=C15*C4 (gross income * COGS %)
Calculate the gross profit for each product. The gross income is calculated because the income
minus the COGS for every product. - ANS-=C15-C16
Calculate the number of personnel that are had to paintings the occasion for every sort of
product. This is calculated because the earnings earlier than the arena rate for every kind of
product, instances the personnel (% of predicted income) for every product kind from the "Model
Inputs" section of the worksheet. Because you can't rent a fragment of an worker, round your
calculations up to the next complete number. - ANS-=ROUNDUP(C26*C7,zero)
(earnings earlier than arena * employees, 0 <- no decimals)
Calculate the profit earlier than the area charge for every product type. This is the gross profit
minus the full operating prices for each type of product, which include the salary costs (but to be
calculated). - ANS-=C17-C24
Calculate the income costs for each product type. This is calculated because the wide variety of
employees wished for every product type times the revenue (consistent with worker) inside the
"Model Inputs" phase. (Employees make the equal salary despite the product kind.) This will
create a circular reference on your worksheet. You will want to trade the alternatives in Excel to
accurately account for the round reference. - ANS-=C28*$C$eight
Calculate the entire working costs for each product type. This is the sum of salary charges (yet
to be calculated), commissions, and the fixed expenses for each product type. -
ANS-=SUM(C21:C23)
Complete the "Arena Fee" portion of the "Profit Summary" phase of the model via referencing
the area fee from the "Model Inputs" section of the worksheet. - ANS-=C9
, Complete the "Gross Profit" part of the "Profit Summary" section of the worksheet with the aid of
totaling the gross profit for all merchandise from the "Gross Profit" section of the version. -
ANS-=SUM(C17:E17)
Complete the "Profit earlier than Arena Fee" portion of the 'Profit Summary" section of the
worksheet through calculating the overall earnings earlier than the area rate for all products
from the "Operating Expenses" phase of the version. - ANS-=SUM(C26:E26)
Complete the "Sales" part of the "Profit Summary" phase of the worksheet by means of
calculating the full sales for all products from the "Gross Profit" section of the version. -
ANS-=SUM(C15:E15)
Complete the "Total Operating Expenses" part of the "Profit Summary" segment of the
worksheet by calculating the entire working expenses for all merchandise from the "Operating
Expenses" phase of the version. - ANS-=SUM(C24:E24)
Complete the data table inside the "What-if Analysis" section of the worksheet to examine the
internet profit for diverse values of the attendance forecast and the arena fee. - ANS-I22 = C37
(Net Profit)
Highlight all - I22:L29
Data-What If Analysis
Row = I13
Column = C9
Enter the fixed charges within the model. Reference the best quantity for every product type
within the "Model Inputs" phase. - ANS-=C6 (already referenced)
For most effective those activities with "Excellent" crowd sizes, how a whole lot overall products
revenue changed into earned? Select the answer closest to your solution from the drop-down
list in cellular J23. - ANS-$7Million
How likely is it that food income would exceed $220,000 if attendance is 18,000 human beings?
Select the correct solution from the drop-down list in mobile L35. - ANS-<five% chance
How lots more money from food sales has been generated at concert events than at other
events, now not such as sporting activities, for occasions in the sample? Select the solution
closest for your solution within the drop-down listing in cellular J31. - ANS-$625,000
In the "Event Profitability Analysis" section of the model, input the projected income for every
product type for this event with the aid of referencing your income forecast from the "Input
Analysis" segment of the version. - ANS-=I16 (calculated previously)
