Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Problem 1: Budgets PR Products Corp. The company estimates that its quarterly sales for next year are as follows: (units) Price per unit is $70

Problem 1: Budgets PR Products Corp. The company estimates that its quarterly sales for next year are as follows: (units) Price per unit is $70 1. 1 Quarter 30,000 units 2. 2 Quarter 50,000 3. 3 Quarter 6,000 4. 4 Quarter 4,000 Accounts receivable at December 31 s on $ 9 0,000. The company estimates that sales are charged 6 0% in the quarter they are made and 4 0% in the following quarter . The final Finished inventory of Finished Goods represents 20% of sales per unit in the next or next quarter. The initial inventory of Finished Goods is 6,000 units. It takes 3 pounds of Raw Material per unit for the necessary production . The desired inventory of Raw Material is 10% of the production needed for the next quarter. The initial inventory of Raw Material is 12,000 units. The cost of Raw Material is $ 1.00 per pound. The accounts payable at 12/31 / X0 add up to $ 60,000. Payments for Raw Material purchases are made at a rate of 70% in the first quarter of the purchase and the other 3 0% in the following quarter . The invested time of direct labor per unit is 1.5 hours. The cost Direct labor per hour is $ 20.00. Requirements: Prepare budgets for Sales, Collections, Production, Raw Material, Disbursements, and Direct Labor. Use the formats that are provided below.

Q1

Q2

Q3

Q4

Year

Total Sales

$

$

$

$

$

Expected Cash Collections

Q1

Q2

Q3

Q4

Year

Account Receivables 12/31 / X0

Total Cash Collections

$

$

$

$

$

Production Budget

Q1

Q2

Q3

Q4

Year

Expected sales

Desired ending inventory

8,500

Total needs

Beginning inventory

Units to be produced

Direct Material Budget

Q1

Q2

Q3

Q4

Year

Units to be produced

RM needed per unit (pounds)

Production needs

Desired ending inventory of RM

4 , 500

Total needs

Beginning inventory of RM

RM to be purchased

Cost of RM per pound

Cost of RM to be purchased

$

$

$

$

$

Expected Cash Disbursements (Payments)

Q1

Q2

Q3

Q4

Year

Account Payable 12/31 / X0

Total Cash Disbursements

$

$

$

$

$

Direct Labor Budget

Q1

Q2

Q3

Q4

Year

Units to be produced

DL Time per unit

Total hours of DL needed

DL Cost per hour

Total DL Cost

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: Ray H. Garrison, Eric W. Noreen, Peter C. Brewer

13th Edition

978-0073379616, 73379611, 978-0697789938

More Books

Students also viewed these Accounting questions