Question: Based on the following assumptions prepare a 3rd spreadsheet with the actual trading activities for the 1st quarter next year. ASSUME THAT DURING THE 1ST

Based on the following assumptions prepare a 3rd spreadsheet with the actual

trading activities for the 1st quarter next year.

ASSUME THAT DURING THE 1ST QUARTER OF NEXT YEAR:

Food revenue was 20% higher than the budget forecasted

Food Cost was 30% higher than the budget forecasted

Beverage sales was 15,000 units

Utilities Expense was $3,000

Wages expense $20,000

Rent expense was $6,500

You are required to monitor the trading activities for Simpsons Pty Ltd for the

first quarter of next year and identify and record in an additional column all

dollar ($) variances from the forecasted budget.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Q:

Question 3: Based on the following assumptions prepare a 3rd spreadsheet with the actual trading activities for the 1st quarter next year. ASSUME THAT DURING THE 1ST QUARTER OF NEXT YEAR: Food...

Q:

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...

Q:

BSBFIM501: Assessment 2- Managing Budgets. I am so bad at this, and don't understand how to do any of this assessment. BSBFIM501 - Assessment 2 Task 1 - Sales Budget Part A (1) The Black Helmet Motor...

Q:

Part B - Case Study/Practical This section has 2 Tasks. You are required to complete both tasks. *IMPORTANT NOTE: SPREADSHEETS MUST BE PREPARED USING MICROSOFT EXCEL SCENARIO Simpsons Pty Ltd is a...

Q:

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...

Q:

Hoyt, Inc. has estimated current year sales (in millions) for the next four quarters. Q1 $240Q2 $250 Q3 $205 Q4 $350 ? Sales for the 1st quarter next year are projected to be $230.? Accounts...

Q:

Each gallon of window cleaner requires 124 ounces of AM972 and 27 ounces of CA38. An ounce of AM972 costs Vaughn $0.14. An ounce of CA38 costs the company $0.24. Vaughn's inventory policy requires...

Q:

i need help with filling out the rest of the chart on chapter 5 number 5 please. Marigold Chemicals has developed a new window cleaner that requires two ingredients, AM972 and CA38, Based on...

Q:

The drop down options: Concord Chemicals has developed a new window cleaner that requires two ingredients, AM972 and CA38. Based on forecasted sales, Concord has developed the following budgeted...

Q:

For the following reactions, predict what the product would be: H3C H3C - H 1. Hg(OAc)2, CH3OH 2. NaBH4

Q:

As controller for Henderson, you are attempting to reconstruct and revise the following balance sheet prepared by a staff accountant at the end of 2016. Henderson Manufacturing Company Balance Sheet...

Q:

If the interest rate money can earn is revised upward, is todays economic value of a given stream of future payments higher or lower? Explain.

Q:

In which of the following should an auditor s report stating an unmodified opinion refer to the lack of consistency when a material change in accounting principle has occurred? Group of answer...

Q:

Adams Company records provide the following information on December 31, 2013 Account Title Amount Additional Paid-in Capitaln Preferred Stock $17,000 Common Stock 75,000 Premium on Bonds Payable...

Q:

TVR Classics specializes in the sale of original and reproduction restoration parts for classic sports cars and muscle cars of the 1960s and 1970s. The classic car industry has grown significantly in...

Q:

aa. 1. Hg(OAc)2, H2NCH,Ph 2. NaBH4 CH3 bb. HSO4, H2O H,SO4 . 1. NaNH2; 2. CH3CH2I 3. Na, NH3

Q:

Design a minimum-mass symmetric three-bar truss (the area of member 1 and that of member 3 are the same) to support a load P, as was shown in Fig. 2.9. The following notation may be used: Pu = P cos...

Q:

What are some strengths and weaknesses of the Social Ecology model of sustainability?

Q:

What are some of the key considerations in system analysis?

Q:

Why is it important to think about feedback loops?