Question

Testbank Question 44: Planning Systems, Inc. has forecast the following unit sales and production for the next year, by quarter:Testbank Question 44 Planning Systems, Inc. has forecast the following unit sales and production for the next year, by quarte

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Solution:

I

II

III

IV

Production (Units)

150

160

140

100

Sales (Units)

120

140

150

120

Requirement of Material A for the Production of Quarter I = 150 Units

Opening Stock of Quarter I = 20% of the Material required for Production of the Quarter I

= 20% of 150 Units = 30 Units

Closing Stock of Quarter I = 20% of the Material required for Production of Quarter II

= 20% of 160 Units = 32 Units

Requirement of Material A for the Production of Quarter II = 160 Units

Opening Stock of Quarter II = Closing Stock of Quarter I = 32 Units

Closing Stock of Quarter II = 20% of the Material required for Production of Quarter III

= 20% of 140 Units = 28 Units

Calculation of the units to be purchased:

Quarter I

Quarter II

Units used for Production (Units)

150

160

Add: Closing Stock (Units)

32

28

182

188

Less: Opening Stock (Units)

30

32

Number of Units to be purchased

152

156

Therefore, the number of units required to be purchased for the Quarter II is 156 Units.

Correct option is 156.

Add a comment
Know the answer?
Add Answer to:
Testbank Question 44: Planning Systems, Inc. has forecast the following unit sales and production for the...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Prepare the sales, production, and direct material budgets by quarters for 2020. American Company is preparing...

    Prepare the sales, production, and direct material budgets by quarters for 2020. American Company is preparing its master budget for 2020. Relevant data pertaining to its sales, production, direct materials budgets are as follows: Sales: Sales for the year are expected to total 1,200,000 units Quarterly sales are 20%, 25%, 30%, and 25% respectively. The sales price is expected to be $ 50 per units for the first three quarters and $55 per unit beginning in the fourth quarter. Sales...

  • The production department of Zan Corporation has submitted the following forecast of units to be produced...

    The production department of Zan Corporation has submitted the following forecast of units to be produced by quarter for the upcoming fiscal year: 4th 1st Quarter 17,000 2nd Quarter 20,000 3rd Quarter 19,000 Units to be produced Quarter 18,000 In addition, 21,250 grams of raw materials inventory is on hand at the start of the 1st Quarter and the beginning accounts payable for the 1st Quarter is $7,200. Each unit requires 5 grams of raw material that costs $1.20 per...

  • The production department of Zan Corporation has submitted the following forecast of units to be produced...

    The production department of Zan Corporation has submitted the following forecast of units to be produced by quarter for the upcoming fiscal year: 1st Units to be produced Quarter 5,200 2nd Quarter 8,200 3rd Quarter 7,209 4th Quarter 6,200 In addition, 6,200 grams of raw materials inventory is on hand at the start of the 1st quarter and the beginning accounts payable for the 1st quarter is $3,080. Each unit requires 8.20 grams of raw material that costs $1.60 per...

  • The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal...

    The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are on account): Budgeted unit sales 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 12,300 13,300 1 5,300 14,300 The selling price of the company's product is $22 per unit. Management expects to collect 75% of sales in the quarter in which the sales are made, 20% in the following quarter, and 5% of sales are expected to be uncollectible. The...

  • Pargo Company is preparing its master budget for 2020. Relevant data pertaining to its sales, production,...

    Pargo Company is preparing its master budget for 2020. Relevant data pertaining to its sales, production, and direct materials budgets are as follows. Sales. Sales for the year are expected to total 1,700,000 units. Quarterly sales are 18%, 23%, 24%, and 35%, respectively. The sales price is expected to be $41 per unit for the first three quarters and $43 per unit beginning in the fourth quarter. Sales in the first quarter of 2021 are expected to be 15% higher...

  • The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal...

    The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are on 1st Quarter 11,200 Budgeted unit sales 2nd Quarter 3rd Quarter 4th Quarter 12,200 14, 200 13,200 The selling price of the company's product is $11 per unit. Management expects to collect 65% of sales in the quarter in which the sales are made, 30% in the following quarter, and 5% of sales are expected to be uncollectible. The beginning...

  • The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal...

    The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are on account): 1st Quarter 11,300 2nd Quarter 12,300 3rd Quarter 14,300 Budgeted unit sales 4th Quarter 13,300 The selling price of the company's product is $12 per unit. Management expects to collect 75% of sales in the quarter in which the sales are made, 20% in the following quarter, and 5% of sales are expected to be uncollectible. The beginning...

  • The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal...

    The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are on account) 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted unit sales 12,800 13,80015,80014,800 The selling price of the company's product is $27 per unit. Management expects to collect 65% of sales in the quarter in which the sales are made 30% in the following quarter, and 5% of sales are expected to be uncollectible. The beginning balance of...

  • The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal...

    The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are on account: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 14,000 Budgeted unit sales 12,000 13,000 15,000 The selling price of the company's product is $19 per unit. Management expects to collect 65% of sales in the quarter in which the sales are made, 30% in the following quarter, and 5% of sales are expected to be uncollectible. The beginning...

  • The marketing dept of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal...

    The marketing dept of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are on account). Budget unit sales: Quarter 1 11,000 Quarter 2 12,000 Quarter 3 14,000 Quarter 4 13,000 The selling price of the product is $18 per unit. Management expects to collect 65% of sales in the quarter in which the sales are made, 30% in the following quarter, and 5% of sales are expected to be uncollectible. The beginning balance...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT