Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

For budget an income statementplease use excel. a) Budget an income statement for the months of January, February and March 2018, with the following information

For budget an income statementplease use excel.

image text in transcribed

a) Budget an income statement for the months of January, February and March 2018, with the following information i) Actual sales for the month of October November and December 2017 Sales forecast for the month of January February and March 2018 Cash sales are 30% and the balance are credit sales. For credit sales 60% of it will be collected in the next month and 20% of it will be collected two months after the sale, and the remaining 20% will be collected three months after the sale. Month October November December January February March Sales (RM) 80,000.00 90,000.00 110,000.00 120,000.00 130,000.00 150,000.00 iv) The purchase of raw material is predicted at 50% of sales and the payments will be made two months later Rentals are RM5 500 per month Salaries are RM6 000 per month vii) The company will pay the building insurance premiums of RM3 800 will be paid in the month of February viii) The purchase of machinery involving a cost of RM60 000 will be made in the month of January ix) Opening cash balance for the month of January was RM20 000 x) The cash balance that the company intends to hold every month is RM15 000

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

The Future Of Auditing

Authors: David Hay

1st Edition

1138477087, 9781138477087

More Books

Students also viewed these Accounting questions

Question

In what ways can confl ict enrich relationships?

Answered: 1 week ago

Question

How do listening and hearing diff er?

Answered: 1 week ago

Question

How does eff ective listening diff er across listening goals?

Answered: 1 week ago