Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Planterio Inc. is preparing budgets for the upcoming quarter ending March 31. Budgeted sales (in units) for the next five months are: January February March

image text in transcribed

image text in transcribed

Planterio Inc. is preparing budgets for the upcoming quarter ending March 31. Budgeted sales (in units) for the next five months are: January February March April May 45,000 135,000 112.500 76,500 78,750 Below is additional information that may be relevant in preparing the budgets. The company produces professional quality planters that sell for $25.00 per unit. To guard against inventory stockouts, the company has a policy of maintaining an ending inventory of 20 percent of the following month's budgeted sales. At the beginning of January, Planterio Corp. had 22,500 units in inventory. Each unit of output requires 2 kilograms of direct material. To guard against stockouts of raw materials, the company has a policy of maintaining a raw materials inventory of 15 percent of the following month's production. At the beginning of January, Planterio Corp. has 32,000 kilograms of direct materials on hand. Each kilogram of direct materials costs $1.50. Each unit of output requires 0.1 hours (6 minutes) of direct labour and employees are paid a standard rate of $22 per hour Planterio Corp. applies overhead using a variable rate of $7.50 per direct labour hour. The fixed overhead is $99,855 per month. Of that amount, $20,000 are non-cash costs, such as depreciation on assets. Planterio Corp. has both fixed and variable components to the selling and administrative expenses. Accountants at Sienna Corp. estimate that the variable selling and administrative 1 expenses are $0.50 per unit sold. Fixed selling and administrative expenses are $140,000 per month, $20,000 are non-cash costs, such as depreciation on assets. Fifty percent of sales are made in cash. The remaining 50% of sales are made on account. The company collects 60% of sales made on account in the month of the sale, 20% in the month following the sale, and 15% in the second month following the sale. Planterio Corporation had total sales of $700,000 in November and $1,050,000 in December Planterio Corporation pays $1.50 per kilogram of direct materials. The company pays of half of its purchases in the month of the purchase and the remaining half in the month following the purchase. At the beginning of the quarter, Planterio Corporation owed its creditors $63,600 for purchases of direct materials. Required: (A) Prepare a sales budget for the months of January, February, and March, and for the quarter. (B) Prepare a production budget for the months of January, February, and March, and for the quarter-end. [Note: you might want to compute the production needs for April since you will need that information for subsection (C)) (C) Prepare the direct materials purchases budget for the months of January, February, and March, and for the quarter-end. (D) Prepare the direct labour budget for the months of January, February, and March, and for the quarter-end. (E) Prepare the overhead budget for the months of January, February, and March, and for the quarter-end. (F) Prepare the ending finished goods inventory budget for the quarter ending March 31. (G) Prepare the accounts receivable collections schedule for the months of January, February, and March (H) Prepare the cash payments on accounts payable schedule for the months of January, February, and March

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_2

Step: 3

blur-text-image_3

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 Understanding And Practice

Authors: Robert Perks

4th Edition

0077139135, 978-0077139131

More Books

Students also viewed these Accounting questions

Question

2. Should a disciplinary system be established at Carter Cleaning?

Answered: 1 week ago