Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Filson Corporation has projected sales and production in units for the second quarter of the coming year as follows: Sales Production April 60,000 70,000

image text in transcribed

Filson Corporation has projected sales and production in units for the second quarter of the coming year as follows: Sales Production April 60,000 70,000 May June 50,000 60,000 70,000 60,000 Cash-related production costs are budgeted at $8 per unit produced. Of these production costs, 45% are paid in the month in which they are incurred and the balance in the following month. Selling and administrative expenses will amount to $80,000 per month. The accounts payable balance on March 31 totals $191,000, which will be paid in April. All units are sold on account for $14 each. Cash collections from sales are budgeted at 60% in the month of sale, 30% in the month following the month of sale, and the remaining 10% in the second month following the month of sale. Accounts receivable on April 1 totaled $575,000 ($105,000 from February's sales and $470,000 from March's sales). Required: a. Prepare a schedule for each month showing budgeted cash disbursements for Tilson Corporation, b. Prepare a schedule for each month showing budgeted cash receipts for Tilson Corporation. Complete this question by entering your answers in the tabs below. Required A Required B Prepare a schedule for each month showing budgeted cash receipts for Tilson Corporation. Total sales April May June $ 60,000 $ 50,000 $ 70,000 Cash receipts: February sales $ March sales 504,000 $ $ 420,000 $ 588,000 252,000 210,000 April sales $ 84,000 May sales June sales Total receipts $ 504,000 $ 672,000 $ 882,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

Managerial Accounting

Authors: John Wild, Ken Shaw

5th edition

978-1259176494, 1259176495, 978-1259347641, 1259347648, 978-0078025600

More Books

Students also viewed these Accounting questions

Question

4 Relate price to consumer perceptions of quality.

Answered: 1 week ago