Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Cash Conscious Inc. is a merchandising company that buys goods for resale. Cash Conscious Inc. is preparing a cash budget for the month of March

image text in transcribed

Cash Conscious Inc. is a merchandising company that buys goods for resale. Cash Conscious Inc. is preparing a cash budget for the month of March 2021 and has collected the following estimated data: NOTE: If some of the boxes below have #VALUE in them it means you haven't entered your student number on the cover tab. 1 Estimated monthly sales in units: January February March April May 1,200 1,300 1,400 1,250 1,450 2 Average selling price is estimated to be $ 14.50 per unit. All sales are credit sales. Estimated collection pattern for credit sales is 30% in the month of sale, 50% in the month after sale and 20% 3 two months after the sale. 4 The company would like to have ending inventory each month equal to 20% of next months sales. 5 Cost of purchases are estimated to be $ 7.50 per unit and are paid in the month of purchase. 6 Depreciation is calculated using the straight-line method. Assume all other annual fixed operating expenses are incurred evenly throughout the year and are paid in the month incurred. Annual Fixed Operating Expenses Advertising $ 12,720.00 Depreciation $ 14,160.00 Insurance $ 15,000.00 Property Taxes $ 13,750.00 Sales and Admin Salaries $ 14,400.00 Required: Prepare Cash Conscious Inc.'s cash budget for March 2021. Assume a March opening cash baland $ 14,000.00 To help you organize this, you will need to: a) Determine the sales budgeted for the first quarter and the amount of cash collected in March. (4 marks) b) Determine the merchandise purchase requirements for March. (3 marks) c) Determine the total cash disbursements for March (purchases and fixed operating expenses). (2 marks) d) Prepare the cash budget in good form (only 4 lines are required - opening cash balance plus receipts minus disbursements equals ending cash balance). (4 m

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

Intermediate Accounting

Authors: Donald E. Kieso, Jerry J. Weygandt, Terry D. Warfield

11th Edition

0471448966, 978-0471448969

More Books

Students also viewed these Accounting questions

Question

1. Walk to the child, look into his or her eyes.

Answered: 1 week ago