Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Miller manufacturing Companys budgeted income statement includes the following data: Miller manufacturing Company March April May June Sales 120 000 90 000 95 000 100

Miller manufacturing Companys budgeted income statement includes the following data:

Miller manufacturing Company

March

April

May

June

Sales

120 000

90 000

95 000

100 000

Commission expense

18 000

13 500

14 250

15 000

Salary expense

30 000

30 000

30 000

30 000

Miscellaneous expense

4 800

3 600

3 800

4 000

Rent expense

3 000

3 000

3 000

3 000

Utilities expense

1 900

1 900

1 900

1 900

Insurance expense

2 100

2 100

2 100

2 100

All sales are made on a cash basis.

The budget assumes that 60% of commission expenses are paid in the month they were incurred and the remaining 40% are paid one month later.

50% of salary expenses are paid in the month incurred and the remaining 50% are paid one month later.

Miscellaneous expense, rent expense and utility expense are assumed to be paid in the same month in which they are incurred.

Insurance was prepaid for the year on 1 January.

The cash balance at 1 April was $ 15 500.

Use the table below to prepare a cash budget for each of the months April, May and June.

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

Marketing Audit Checklists A Guide To Effective Marketing Resource Realization

Authors: Aubrey Wilson

1st Edition

0077077601, 978-0077077600

More Books

Students also viewed these Accounting questions

Question

=+b. If the trend of the time-series plot were to continue,

Answered: 1 week ago