Tilson Corporation has projected sales and production in...

90.2K

Verified Solution

Question

Accounting

image
image
Tilson Corporation has projected sales and production in units for the second quarter of the coming year as follows: April May Sales 47,000 37.000 57,000 Production 57.000 47,000 47,000 June Cash-related production costs are budgeted at $5 per unit produced. Of these production costs, 50% are paid in the month in which they are incurred and the balance in the following month. Selling and administrative expenses will amount to $50,000 per month. The accounts payable balance on March 31 totals $176,000, which will be paid in April. All units are sold on account for $17 each. Cash collections from sales are budgeted at 50% in the month of sale, 40% 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 $455,000 ($95,000 from February's sales and $360,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 Prepare a schedule for each month showing budgeted cash disbursements for Tilson Corporation April May June Production cost Cash disbursement Production costs this month (50%) Production cost prior month (50.0%) Seling and administrative Total disbursements $ 0$ Hei Required) Tilson Corporation has projected sales and production in units for the second quarter of the coming year as follows: May Sales Production April 47,000 57,000 37,000 47,000 June 57,000 47,000 Cash-related production costs are budgeted at $5 per unit produced. Of these production costs, 50% are paid in the month in which they are incurred and the balance in the following month. Selling and administrative expenses will amount to $50,000 per month. The accounts payable balance on March 31 totals $176,000, which will be paid in April. All units are sold on account for $17 each. Cash collections from sales are budgeted at 50% in the month of sale, 40% 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 $455,000 ($95,000 from February's sales and $360,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. April May June Total sales Cash receipts: February sales March sales April sales May sales June sales Total receipts $ 0 0

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students