C268 QUESTIONS AND
VERIFIED CORRECT
ANSWERS GRADED A+
[LATEST] 100% GUARANTEED
PASS
Calculate the gross profit for each product. The gross profit is calculated as the sales minus the
COGS for each product. - CORRECT ANSWER-=C15-C16
Which product generates the largest gross profit? Select the correct answer from the drop-
down list in cell L38. - CORRECT ANSWER-Merchandise (line 17)
Calculate the commissions paid for each product type. The commissions paid are calculated as
the expected sales for each product type times the commission percentage from the "Model
Inputs" section of the model. - CORRECT ANSWER-=C15*C5 (sales & commission %)
Enter the fixed costs in the model. Reference the appropriate amount for each product type in
the "Model Inputs" section. - CORRECT ANSWER-=C6 (already referenced)
Calculate the total operating expenses for each product type. This is the sum of salary expenses
(yet to be calculated), commissions, and the fixed costs for each product type. - CORRECT
ANSWER-=SUM(C21:C23)
, Calculate the profit before the arena fee for each product type. This is the gross profit minus the
total operating expenses for each type of product, including the salary expenses (yet to be
calculated). - CORRECT ANSWER-=C17-C24
Calculate the number of employees that are needed to work the event for each type of product.
This is calculated as the profit before the arena fee for each type of product, times the
employees (% of expected profit) for each product type from the "Model Inputs" section of the
worksheet. Because you cannot hire a fraction of an employee, round your calculations up to
the next whole number. - CORRECT ANSWER-=ROUNDUP(C26*C7,0)
(profit before arena * employees, 0 <- no decimals)
Which product will require the fewest employees? Select the correct answer from the drop-
down list in cell L40. - CORRECT ANSWER-row 28 (lowest amount)
Calculate the salary expenses for each product type. This is calculated as the number of
employees needed for each product type times the salary (per employee) in the "Model Inputs"
section. (Employees make the same salary despite the product type.) This will create a circular
reference in your worksheet. You will need to change the options in Excel to appropriately
account for the circular reference. - CORRECT ANSWER-=C28*$C$8
Complete the "Sales" portion of the "Profit Summary" section of the worksheet by calculating
the total sales for all products from the "Gross Profit" section of the model. - CORRECT
ANSWER-=SUM(C15:E15)
Complete the "Gross Profit" portion of the "Profit Summary" section of the worksheet by
totaling the gross profit for all products from the "Gross Profit" section of the model. - CORRECT
ANSWER-=SUM(C17:E17)
Complete the "Total Operating Expenses" portion of the "Profit Summary" section of the
worksheet by calculating the total operating expenses for all products from the "Operating
Expenses" section of the model. - CORRECT ANSWER-=SUM(C24:E24)
VERIFIED CORRECT
ANSWERS GRADED A+
[LATEST] 100% GUARANTEED
PASS
Calculate the gross profit for each product. The gross profit is calculated as the sales minus the
COGS for each product. - CORRECT ANSWER-=C15-C16
Which product generates the largest gross profit? Select the correct answer from the drop-
down list in cell L38. - CORRECT ANSWER-Merchandise (line 17)
Calculate the commissions paid for each product type. The commissions paid are calculated as
the expected sales for each product type times the commission percentage from the "Model
Inputs" section of the model. - CORRECT ANSWER-=C15*C5 (sales & commission %)
Enter the fixed costs in the model. Reference the appropriate amount for each product type in
the "Model Inputs" section. - CORRECT ANSWER-=C6 (already referenced)
Calculate the total operating expenses for each product type. This is the sum of salary expenses
(yet to be calculated), commissions, and the fixed costs for each product type. - CORRECT
ANSWER-=SUM(C21:C23)
, Calculate the profit before the arena fee for each product type. This is the gross profit minus the
total operating expenses for each type of product, including the salary expenses (yet to be
calculated). - CORRECT ANSWER-=C17-C24
Calculate the number of employees that are needed to work the event for each type of product.
This is calculated as the profit before the arena fee for each type of product, times the
employees (% of expected profit) for each product type from the "Model Inputs" section of the
worksheet. Because you cannot hire a fraction of an employee, round your calculations up to
the next whole number. - CORRECT ANSWER-=ROUNDUP(C26*C7,0)
(profit before arena * employees, 0 <- no decimals)
Which product will require the fewest employees? Select the correct answer from the drop-
down list in cell L40. - CORRECT ANSWER-row 28 (lowest amount)
Calculate the salary expenses for each product type. This is calculated as the number of
employees needed for each product type times the salary (per employee) in the "Model Inputs"
section. (Employees make the same salary despite the product type.) This will create a circular
reference in your worksheet. You will need to change the options in Excel to appropriately
account for the circular reference. - CORRECT ANSWER-=C28*$C$8
Complete the "Sales" portion of the "Profit Summary" section of the worksheet by calculating
the total sales for all products from the "Gross Profit" section of the model. - CORRECT
ANSWER-=SUM(C15:E15)
Complete the "Gross Profit" portion of the "Profit Summary" section of the worksheet by
totaling the gross profit for all products from the "Gross Profit" section of the model. - CORRECT
ANSWER-=SUM(C17:E17)
Complete the "Total Operating Expenses" portion of the "Profit Summary" section of the
worksheet by calculating the total operating expenses for all products from the "Operating
Expenses" section of the model. - CORRECT ANSWER-=SUM(C24:E24)
