Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The data below pertains to the third quarter of Al Ain Company which manufactures toys. Below is the estimated sales (in units): July 20,000 August

The data below pertains to the third quarter of Al Ain Company which manufactures toys.

Below is the estimated sales (in units):

July

20,000

August

50,000

September

65,000

October

42,000

November

40,000

December

35,000

  1. The selling price of the toys is $10 per unit.
  2. All sales are on account. Based on past experience, sales are collected in the following pattern:

Month of sale

25%

Month following sale

70%

Uncollectible

5%

  1. Sales for June totaled $400,000.
  2. The company maintains finished goods inventories equal to 20% of the following month's sales. This requirement will be met at the end of June.
  3. Each toy requires 3 pounds of raw materials.
  4. The company requires that the ending inventory of raw materials be equal to 20% of the following month's production needs.
  5. The raw material costs $1.50 per pound.
  6. 40% of a month's purchases of raw materials is paid for in the month of purchase; the remainder is paid for in the following month.

  1. The accounts payable on June 30 will be $80,000.

Required: prepare

1-Prepare a sales budget, by month and in total, for the quarter

2- Prepare a schedule of expected cash collections, by month and in total, for the quarter.

3- Prepare a production budget for each months of the quarter

4- Prepare a direct materials budget, by month and in total, for the quarter

5-Prepare a direct materials budget, by month and in total, for the quarter

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

Schaums Outline Of Financial Accounting

Authors: Jae Shim, Joel Siegel

2nd Edition

0071762507, 978-0071762502

More Books

Students also viewed these Accounting questions

Question

What is IUPAC system? Name organic compounds using IUPAC system.

Answered: 1 week ago

Question

What happens when carbonate and hydrogen react with carbonate?

Answered: 1 week ago