Question

ACTIVITY 1:

SALES AND COGS ACTIVITIES FOR 2015

The restaurant sold 54,600 take away meals, and the price per meal was $10.50. The food cost per meal sold was $4.60. Also 20,000 units of soft drinks were sold during the year. Soft drinks are sold for $2.50 and the cost price was $0.80.


Based on the above Sales and COGS activities for 2015;

Prepare a spreadsheet with the average monthly Sales for food and drinks and the average monthly COGS for meals and drinks; in addition include end columns for the annual totals and another with the average quarterly totals.

Answer 1

Answer on Question #65187 - Economics - Accounting

ACTIVITY 1:

SALES AND COGS ACTIVITIES FOR 2015

The restaurant sold 54,600 take away meals, and the price per meal was $10.50. The food cost per meal sold was $4.60. Also 20,000 units of soft drinks were sold during the year. Soft drinks are sold for $2.50 and the cost price was $0.80.

Based on the above Sales and COGS activities for 2015;

Prepare a spreadsheet with the average monthly Sales for food and drinks and the average monthly COGS for meals and drinks; in addition include end columns for the annual totals and another with the average quarterly totals.

Answer:

Spreadsheet

annual totals = amount * selling price

average quarterly totals = annual totals / 4 quarters

average monthly = annual totals / 12 months

Answer provided by https://www.AssignmentExpert.com