WGU C268 Spreadsheets EXAM
QUESTIONS WITH CORRECT
SOLUTIONS (VERIFIED ANSWERS)
||100% GUARANTEED
PASS||UPDATED 2026/2027
SYLLABUS||<<LATEST VERSION>>
How likely is it that food sales would exceed $220,000 if attendance is 18,000
people? Select the correct answer from the drop-down list in cell L35. - ANSWER
✓ <5% chance
In the "Event Profitability Analysis" section of the model, enter the projected sales
for each product type for this event by referencing your sales forecast from the
"Input Analysis" section of the model. - ANSWER ✓ =I16
Calculate the cost of goods sold (COGS) for each product. The COGS is
calculated as the sales for each product type times the COGS percentage from the
"Model Inputs" section of the model for that product type. - ANSWER ✓
=C15*C4
Calculate the gross profit for each product. The gross profit is calculated as the
sales minus the COGS for each product. - ANSWER ✓ =C15-C16
Which product generates the largest gross profit? Select the correct answer from
the drop-down list in cell L38. - ANSWER ✓ Merchandise
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. - ANSWER ✓ =C15*C5
Enter the fixed costs in the model. Reference the appropriate amount for each
product type in the "Model Inputs" section. - ANSWER ✓ =C6
, 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. - ANSWER ✓ =SUM(C21,C22,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). - 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. - ANSWER ✓
=ROUNDUP(C26*C7,0)
Which product will require the fewest employees? Select the correct answer from
the drop-down list in cell L40. - ANSWER ✓ Programs
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. - 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. - 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. - 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. - ANSWER ✓
=SUM(C21,C22,C23)
QUESTIONS WITH CORRECT
SOLUTIONS (VERIFIED ANSWERS)
||100% GUARANTEED
PASS||UPDATED 2026/2027
SYLLABUS||<<LATEST VERSION>>
How likely is it that food sales would exceed $220,000 if attendance is 18,000
people? Select the correct answer from the drop-down list in cell L35. - ANSWER
✓ <5% chance
In the "Event Profitability Analysis" section of the model, enter the projected sales
for each product type for this event by referencing your sales forecast from the
"Input Analysis" section of the model. - ANSWER ✓ =I16
Calculate the cost of goods sold (COGS) for each product. The COGS is
calculated as the sales for each product type times the COGS percentage from the
"Model Inputs" section of the model for that product type. - ANSWER ✓
=C15*C4
Calculate the gross profit for each product. The gross profit is calculated as the
sales minus the COGS for each product. - ANSWER ✓ =C15-C16
Which product generates the largest gross profit? Select the correct answer from
the drop-down list in cell L38. - ANSWER ✓ Merchandise
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. - ANSWER ✓ =C15*C5
Enter the fixed costs in the model. Reference the appropriate amount for each
product type in the "Model Inputs" section. - ANSWER ✓ =C6
, 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. - ANSWER ✓ =SUM(C21,C22,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). - 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. - ANSWER ✓
=ROUNDUP(C26*C7,0)
Which product will require the fewest employees? Select the correct answer from
the drop-down list in cell L40. - ANSWER ✓ Programs
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. - 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. - 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. - 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. - ANSWER ✓
=SUM(C21,C22,C23)
