Answer to Question #65187 in Accounting for jane nguyen

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.