Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

Mercy Sports Shop started operations on 1 st January, 2020. The firm sells sports shoes in shopping malls. The company expects a 20 per cent

  1. Mercy Sports Shop started operations on 1st January, 2020. The firm sells sports shoes in shopping malls. The company expects a 20 per cent increase in sales per month for November and December 2020. Mercy has budgeted sales as indicated in the following table:

Sales

October

November

December

Total

Cash sales

Ksh 300,000/=

Sales on account

Ksh 900,000/=

Total budget sales

Ksh 1,200,000/=

Required:-

  1. Using excel complete the sales budget by filling in the missing amounts.
  2. Determine the amount of sales revenue that will appear on the pro-forma income statement for the companys fourth quarter 2020.

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

Recommended Textbook for

Auditing Cases An Active Learning Approach

Authors: Mark S. Beasley, Frank A. Buckless, Steven M. Glover, Douglas F. Prawitt

2nd Edition

0130674842, 978-0130674845

Students also viewed these Finance questions