Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Tomlinson Retail Store seeks your assistance to develop cash and other budget information for May, June and July 20SY. At April 30, 20SY, the company

  • Tomlinson Retail Store seeks your assistance to develop cash and other budget information for May, June and July 20SY. At April 30, 20SY, the company had cash of P5,500, accounts receivable of P437,000, inventories of P309,400, and accounts payable of P133,055. The budget is based on the following assumptions: a. Sales 1. Each month’s sales are billed on the last day of the month. 2. Customers are allowed 3% discount if payment is made within 10 days after the billing date. Accounts receivable are booked gross. 3. Sixty percent of the billings are collected within the discount period, 25% are collected by the end of the month, 9% are collected by the end of the second month, and 6% prove uncollectible. b. Purchases 1. 54% of all purchases of materials and selling, general, and administrative expenses are paid the month purchased and the remainder in the following month. 2. Each month’s months units of ending inventory is equal to 130% of the next month’s units of sales. 3. The cost of each unit of inventory is P20. 4. Selling, general and administrative expenses, of which P2,000 is depreciation, are equal to 15% of the current month’s sales. Actual and projected sales are as follows: 20SY Pesos Units 20SY Pesos Units March 354,000 11,800 June 342,000 11,400 April 363,000 12,100 July 360,000 12,000 May 357,000 11,900 August 366,000 12,200 REQUIRED: Prepare cash forecast for the months of May, June and July 20SY, based on the above data and supported by the following schedules: a. Cash receipts from accounts receivable. b. Cash disbursements on accounts payable. c. Purchases of inventory d. Cash disbursements on selling, general and administrative expenses.

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

Accounting Information Systems Controls And Processes

Authors: Leslie Turner, Andrea B. Weickgenannt

1st Edition

0471479519, 9780471479512

More Books

Students also viewed these Accounting questions

Question

What background experience do you have?

Answered: 1 week ago

Question

4. What means will you use to achieve these values?

Answered: 1 week ago