Question
In: Finance
Mercy Sports Shop started operations on 1st January, 2020. The firm sells sports shoes in shopping...
- 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:-
- Using excel complete the sales budget by filling in the missing amounts.
- Determine the amount of sales revenue that will appear on the pro-forma income statement for the company’s fourth quarter 2020.
Solutions
Expert Solution
i )
| Sales | October | November | December | Total |
| Cash sales | 300000 | 360000 | 432000 | 1092000 |
| Sales on account | 900000 | 1080000 | 1296000 | 3276000 |
| Total budget sales | 1200000 | 1440000 | 1728000 | 4368000 |
ii) The amount of sales revenue that will appear on the pro-forma income statement for the company’s fourth quarter 2020. is the sum if total budget sales for October, Nov and Dec = $ 4368,000
Workings
jeff jeffy answered 1 year agoRelated Solutions
On 1st January 2020 Tom Shanks started trading as Shanks Real Estate, and completed the following...
On 1st January 2020 Tom Shanks started
trading as Shanks Real Estate, and completed the following
transactions regarding the business in the first
month:
Jan 1: Tom Shanks transferred cash from his personal
bank account to the business bank account in order to start
operations, $25,000.
Jan 4: The business paid a year’s rent in advance for
office space, $11,880
Jan 5: The business purchased a motor vehicle, $22,000.
A deposit of $6,000 was paid with the remainder financed by...
On 1st January 2020 Tom Shanks started trading as Shanks Real Estate, and completed the following...
On 1st January 2020
Tom Shanks started trading as Shanks Real Estate, and completed the
following transactions regarding the business in the first
month:
Jan 1: Tom Shanks transferred cash from his personal
bank account to the business bank account in order to start
operations, $25,000.
Jan 4: The business paid a year’s rent in advance for
office space, $11,880
Jan 5: The business purchased a motor vehicle, $22,000.
A deposit of $6,000 was paid with the remainder financed by...
Sunland Sports began operations on January 2, 2020. The following stock record card for footballs was...
Sunland Sports began operations on January 2, 2020. The
following stock record card for footballs was taken from the
records at the end of the year.
Date
Voucher
Terms
Units
Received
Unit Invoice
Cost
Gross Invoice
Amount
1/15
10624
Net 30
63
$27
$1,701
3/15
11437
1/5, net 30
78
21
1,638
6/20
21332
1/10, net 30
103
20
2,060
9/12
27644
1/10, net 30
97
16
1,552
11/24
31269
1/10, net 30
89
15
1,335
Totals
430
$8,286
A...
Novak Sports began operations on January 2, 2020. The following stock record card for footballs was...
Novak Sports began operations on January 2, 2020. The following
stock record card for footballs was taken from the records at the
end of the year.
Date
Voucher
Terms
Units
Received
Unit Invoice
Cost
Gross Invoice
Amount
1/15
10624
Net 30
75
$32
$2,400
3/15
11437
1/5, net 30
90
25
2,250
6/20
21332
1/10, net 30
115
24
2,760
9/12
27644
1/10, net 30
109
19
2,071
11/24
31269
1/10, net 30
101
17
1,717
Totals
490
$11,198
A...
Crane Sports began operations on January 2, 2020. The following stock record card for footballs was...
Crane Sports began operations on January 2, 2020. The following
stock record card for footballs was taken from the records at the
end of the year. Date Voucher Terms Units Received Unit Invoice
Cost Gross Invoice Amount 1/15 10624 Net 30 51 $22 $1,122 3/15
11437 1/5, net 30 66 18 1,188 6/20 21332 1/10, net 30 91 17 1,547
9/12 27644 1/10, net 30 85 13 1,105 11/24 31269 1/10, net 30 77 12
924 Totals 370 $5,886 A...
Exercise 8-17 Novak Sports began operations on January 2, 2020. The following stock record card for...
Exercise 8-17
Novak Sports began operations on January 2, 2020. The following
stock record card for footballs was taken from the records at the
end of the year.
Date
Voucher
Terms
Units
Received
Unit Invoice
Cost
Gross Invoice
Amount
1/15
10624
Net 30
75
$32
$2,400
3/15
11437
1/5, net 30
90
25
2,250
6/20
21332
1/10, net 30
115
24
2,760
9/12
27644
1/10, net 30
109
19
2,071
11/24
31269
1/10, net 30
101
17
1,717
Totals
490...
Jimmy Adams , on March 1st 2020, started a new accounting practice called X-Factor Accounting with...
Jimmy Adams , on March 1st 2020, started a new accounting
practice called X-Factor Accounting with the aim to provide the
book keeping services to small and medium business organization in
Lower Mainland. During its first month of operations following
transactions have occurred.
March 1st - Adams invested $ 50,000 in cash and office
equipment worth $ 12,000.
March 1st - Paid $ 9,000 cash for three months rent for an
office, in advance.
March 2nd - Paid $ 1,000...
Job Order Costing The ABC Company builds residential housing. The company started operations on June 1st,...
Job Order Costing
The ABC Company builds residential housing. The company started
operations on June 1st, 2018. Below are transactions
that occurred in the first month of operations (June 2018)
Journal Entries:
June 1) ABC Company sold common stock for $1,500,000 in cash.
The company issued 15,000 shares of $100 Par stock.
June 2) ABC Company purchased $300,000 of building materials.
Paying $100,000 cash and the rest on account due in 45 days. No
credit terms were given.
June 3)...
Job Order Costing The ABC Company builds residential housing. The company started operations on June 1st,...
Job Order Costing
The ABC Company builds residential housing. The company started
operations on June 1st, 2018. Below are transactions
that occurred in the first month of operations (June 2018)
Journal Entries:
June 1) ABC Company sold common stock for $1,500,000 in cash.
The company issued 15,000 shares of $100 Par stock.
June 2) ABC Company purchased $300,000 of building materials.
Paying $100,000 cash and the rest on account due in 45 days. No
credit terms were given.
June 3)...
Job Order Costing The ABC Company builds residential housing. The company started operations on June 1st,...
Job Order Costing
The ABC Company builds residential housing. The company started
operations on June 1st, 2018. Below are transactions
that occurred in the first month of operations (June 2018)
Journal Entries:
June 1) ABC Company sold common stock for $1,500,000 in cash.
The company issued 15,000 shares of $100 Par stock.
June 2) ABC Company purchased $300,000 of building materials.
Paying $100,000 cash and the rest on account due in 45 days. No
credit terms were given.
June 3)...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- NPV Your division is considering two investment projects, each of which requires an up-front expenditure of...
- Please repond with a 200 word limit paragraph no copy or paste your own words!!! What...
- Participant Reactivity Think about how participants might react to environmental cues in an experimental situation and...
- Describe scenarios when you would use a Fixed-size virutal disk, a Dynamic virtual disk, and a...
- A conductive sphere with radius ? = 1 ? has been increased to the potential ?0...
- Define a char variable. Read a char value from the keyboard into the variable. Print the...
- If you wanted to store a birthday within code, what class would you use in Java?...
ADVERTISEMENT