Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Sunflower Corporation makes one product and has provided the following information to help prepare the master budget for the next four months of operations: Budgeted

Sunflower Corporation makes one product and has provided the following information to

help prepare the master budget for the next four months of operations:

Budgeted selling price per unit $103

Budgeted unit sales (all on credit):

October 9,500

November 10,700

December 9,800

January 10,800

Raw materials requirement per unit of output 4 pounds

Raw materials cost $5.00 per pound

Direct labor requirement per unit of output 2.8 direct labor-hours

Direct labor wage rate $19.00 per direct labor-hour

Variable selling and administrative expense $1.60 per unit sold

Fixed selling and administrative expense $80,000 per month

Credit sales are collected:

40% in the month of the sale

60% in the following month

Raw materials purchases are paid:

40% in the month of purchase

60% in the following month

The ending finished goods inventory should equal 20% of the following month's sales.

The ending raw materials inventory should equal 40% of the following month's raw

materials production needs

Required (PLEASE BE SURE TO SHOW COMPUTATIONS FOR EACH PART SEPARATELY.

a. What are the budgeted sales for November?

b. What are the expected cash collections for November?

c. What is the budgeted accounts receivable balance at the end of November?

d. According to the production budget, how many units should be produced in November?

e. If 40,000 pounds of raw materials are needed for production in December, how many pounds of raw materials should be purchased in November?

f. What is the estimated cost of raw materials purchases for November?

g. If the cost of raw material purchases in October is $201,040, then in November what are the total estimated cash disbursements for raw materials purchases?

Production Budget

October

November

December

Sales units

9500

10700

9800

Add : Desired Ending Inventory

2140

1960

2160

Total Goods Required

11640

12660

11960

Less : Beginning Inventory

1900

2140

1960

Production Required

9740

10520

10000

Direct Material Budget

October

November

December

Production Required

9740

10520

10000

Raw Material Per unit

4

4

4

Raw Material for Production

38960

42080

40000

Add : Desired Ending Inventory

16832

16000

Total Material Required

55792

58080

Less : Beginning Inventory

15584

16832

Material to be purchased

40208

41248

Cost per Pound

$ 5.00

$ 5.00

Raw material purchase cost

$ 201,040

$ 206,240

NEED ANSWER FOR BELOW

h. What is the estimated accounts payable balance at the end of November?

i. What is the estimated raw materials inventory balance at the end of November?

j. What is the total estimated direct labor cost for November assuming the direct labor workforce is adjusted to match the hours required to produce the forecasted number of units produced?

k. For simplicity, we will assume that there is no fixed manufacturing overhead and that the variable manufacturing overhead is $7.00 per direct labor-hour. What is the estimated unit product 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

Effective Auditing For Corporates Ensuring That All The Risks Are Covered

Authors: Bloomsbury, Joe Oringel

1st Edition

1849300445, 978-1849300445

More Books

Students also viewed these Accounting questions