Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Could anyone pliz help with the assignment question. Questions Quinn Engineering's Accountant has just finished the monthly figures for September. He has prepared the following

image text in transcribed

image text in transcribed

Could anyone pliz help with the assignment question.

Questions Quinn Engineering's Accountant has just finished the monthly figures for September. He has prepared the following schedules showing the results for September and for the quarter to September; budgeted and actual: Last Year Data: REX SUPERMARKETS Performance Analysis and Variance Report DECEMBER 2020 JAN TO DEC 2020 Budget Actual Budget Actual SALES Sales (units) 350 500 5000 5550 Selling Price Per Unit $30 $30 $30 $30 TOTAL SALES $10,500 $15,000 $150,000 $166,500 LESS: Cost of Goods Sold $7,000 $10,000 $100,000 $111,000 GROSS PROFIT $3,500 $5,000 $50,000 $55,500 LESS OPERATING EXP Selling $550 $850 $8,500 $12,000 $11,500 $9,500 Administration $1,000 $800 Financial $250 $190 $4,500 $2,540 TOTAL OPERATING EXP $1,800 $1,840 $25,000 $23,540 NET PROFIT $1,700 $3,160 $25,000 $31,960 This Year's Data: REX SUPERMARKET Performance Analysis and Variance Report MARCH 2021 JAN TO MAR 2021 Budget Actual Budget Actual 400 450 1420 1650 SALES Sales (units) Selling Price Per Unit TOTAL SALES $30 $30 $30 $30 $12,000 $13,500 $42,600 $49,500 LESS: Cost of Goods Sold $8,000 $9,000 $28,400 $33,000 GROSS PROFIT $4,000 $4,500 $14,200 $16,500 LESS OPERATING EXP Selling $1,800 $600 $950 $400 $1,050 $1,600 $3,100 Administration $2,850 Financial $450 $300 $1,100 $980 TOTAL OPERATING EXP $2,000 $1,750 $5,750 $5,680 NET PROFIT $2,000 $2,750 $8,450 $10,820 Required: i. Prepare Full Variance Report Comparing Budget to Actual for: a. December 2020 b. January to December 2020 ii. Prepare Full Variance Report Comparing Budget to Actual for: March 2021 b. January to March 2021 a. ii. Quinn Engineering's CFO had discussed that any variance within 10% is immaterial (manageable). The CFO has specifically asked you to: a. Provide some reasons for any variance exceeding the limit above b. Provide some recommendation the business can implement to decrease the variance percentages. =

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions