Make sales and cogs activities for current year

Assignment Help Financial Accounting
Reference no: EM132593307

SCENARIO

Simpsons Pty Ltd is a small take away restaurant located in Sydney CBD. The restaurant is owned by Mr & Mrs John Spice. The restaurant started its activities in January current year. In December current year the following information was collected:

SALES AND COGS ACTIVITIES FOR CURRENT YEAR

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.

BUDGET FORECASTING FOR NEXT YEAR

The owners estimated that for the .next year the price per take away meal could be increased to $13.00. They have also predicted that sales (in units) would be increased by 10% in next year. The owners have entered into a monthly Contract with the soft drinks supplier. According to the Contract the restaurant must purchase a minimum of 2,000 units of soft drinks per month and the cost price will be reduced to $0.50 per unit. The restaurant owners decided to reduce the selling price of soft drinks to $1.50 in order to increase sales (in units) by 50% and are expecting to meet the required selling demand.

The owners have anticipated the following expenses for next year:

ANTICIPATED YEARLY EXPENSES FOR NEXT YEAR

Cost of Goods Sold (food + beverage) $291,276

Rent $4,000

Utilities $10,000

Wages $60,000

Miscellaneous $6,000

Problem 1: Based on the above Sales and COGS activities for current year; spreadsheet with annual Sales for food and drinks and COGS for meals and drinks; in addition include columns for the monthly average and quarterly average.

Reference no: EM132593307

Questions Cloud

Analyze how the role of the government may affect market : Analyze how the role of the government may affect your market structure's ability to price its products.
Determine what is the target variable cost per mouse : A company believes it can sell 5,100,000, If the company desires to make a profit $2,000,000 on the mouse, what is the target variable cost per mouse?
Determine what is the full selling price of a globe : Management estimates that the variable cost of the globe, Assuming sales of 1,200 units, what is the full selling price of a globe with a 0.25 markup?
Analyze the historical and contemporary antecedents : Evaluate critically the theories, methods of working with the selected population, and culturally relevant research related to your selected population
Make sales and cogs activities for current year : Make Sales and COGS activities for current year; spreadsheet with annual Sales for food and drinks and COGS for meals and drink.
Working with the lgbtq population : Discuss similarities and differences in the several groups contained within the LGBTQ community and Are there similarities between any of these groups
What type of compensation and benefits organization : Discuss what type of compensation and benefits an organization could offer to engage, attract, recruit, and retain a diverse and strong workforce.
Positive and one negative externality in community : Describe at least one positive and one negative externality in your community. Describe who benefits (positive) or suffers
How identify the amount and timing of bruce net cash : Bruce bought a 210-day bank bill with face value,Calculate the yield (simple interest, in percent per annum) he will achieve on his investment in the bank bill.

Reviews

Write a Review

Financial Accounting Questions & Answers

  Financial statement analysis and preparation

Financial Statement Analysis and Preparation

  Shareholder of a company

Describe the ways that a person can become a shareholder of a company. Why Wal-Mart would split its stock?

  Financial and accounting principles

An understanding of financial and accounting principles can be a valuable tool for managers. While not all managers will find themselves calculating financial ratios or preparing annual financial data.

  Prepare a statement of cash flow using the direct method

Prepare a Statement of Cash Flow using the Direct Method and Prepare the Operations section of the Statement of Cash Flow using the Indirect Method.

  Financial accounting assignment

This assignment has one case study and two question apart from case study. Questions related to document Liquidation question and Company financial statements question - Torquay Limited

  Prepare general journal entries for goela

Prepare general journal entries for Goela Ltd

  Principles of financial accounting

Prepare the journal entry to record the acquisition of the assets.

  Prepare general journal entries to record the transactions

Prepare general journal entries to record the transactions, assuming use of the periodic inventory system

  Global reporting initiative

Compare the view espoused by the economist Milton Friedman about the social responsibilities of business with the views express by Stigler.

  Explain the iasb conceptual frameworks

Explain the IASB Conceptual Framework's perspective of users and their decisions.

  Determine the company''s financial statements

T he focus of the report is to determine the extent to which you are comfortable relying on the financial statements as presented by management .

  Computation of free cash flow

Computation of Free Cash Flow

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd