Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Gift4U provided the following sales information for the month of August: July Actual August Budget Cash sales $ 23,400.00 $ 21,600.00 Credit sales 132,600.00 158,400.00

Gift4U provided the following sales information for the month of August:

July Actual August Budget
Cash sales $ 23,400.00 $ 21,600.00
Credit sales 132,600.00 158,400.00
Total sales $156,000.00 $180,000.00

For credit sales, the collection pattern is as follows:

Month of sales 60%
Month following sales 35%

Based on past experience, the company estimates the remaining credit sales are uncollectible.

Inventory purchases average 55% of current month's total sales.

Payments for inventory are made as follows:

Month of purchase 30%
Month following purchase 70%

Other expenses are as follows:

Salaries and wages per month $ 11,484.00
Rent per month $ 3,960.00
Utilities per month $ 5,720.00
Insurance per quarter to be paid in August $ 990.00
Depreciation expenses per month $ 1,650.00

August 1 cash balance is $6,912.00.

Required:

Prepare a cash budget for the month of August and use it to answer the following questions.

Cash sales and collections on account for the month are $_____________.

Payments for inventory for the month are $________________.

Payments for all other expenses for the month are $______________.

The ending cash balance at the end of the month is $____________.

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

College Accounting A Contemporary Approach

Authors: David Haddock, John Price, Michael Farina

5th Edition

126078035X, 978-1260780352

More Books

Students also viewed these Accounting questions

Question

Name one exclusion under the Levy Cap law.

Answered: 1 week ago

Question

Peoples understanding of what is being said

Answered: 1 week ago

Question

The quality of the proposed ideas

Answered: 1 week ago