Question

Question #1: A company manufactures widgets.   Based on an analysis, we find that each widget needs...

Question #1: A company manufactures widgets.   Based on an analysis, we find that each widget needs 3/4 pound of “gunk.” The following is information on the budgeted production of widgets in units for the following three months:

                                                   July               August         September

Budgeted production               21,000             20,000             24,000

We know that this company desires to maintain monthly ending inventories of “gunk” amounting to 25% of the following month's budgeted production needs. The cost per pound of “gunk” is $2.12.

Instructions

Prepare a direct materials purchases budget for the month of August.

Question #3

Stovall Company’s management is trying to predict collections from customers for the months of October and November. Management estimates that credit sales for August, September, October, and November will be $270,000, $375,000, $420,000, and $240,000, respectively. Typically, the Company collects from its customers as follows:

            In month of sale                                       25%

            In first month after sale                            60%

            In second month after sale                      10%

Instructions

Prepare a schedule to determine the collections from customers in October and November. Be sure that you show your calculations.

Homework Answers

Answer #1

Question 1

Direct materials purchases budget

August
Materials required for production 15,000 (20,000*3/4)
Desired ending inventory 4,500 (24,000*3/4*25%)
Production needs 19,500
Beginning inventory (3,750) (20,000*3/4*25%)
Raw material purchases 15,750
Cost per pound $2.12
Direct material purchases $33,390

Question 2

October November
Cash collected in the month of sale $105,000 ($420,000*25%) $60,000 ($240,000*25%)
Cash collected in the month following the sale $225,000 ($375,000*60%) $252,000 ($420,000*60%)
Cash collected in the second month after the sale $27,000 ($270,000*10%) $37,500 ($375,000*10%)
Total cash collections $357,000 $349,500
Know the answer?
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
Similar Questions
Bluebear Corporation budgeted sales for the last four months of 2018: Month Sales September $360,000 October...
Bluebear Corporation budgeted sales for the last four months of 2018: Month Sales September $360,000 October 400,000 November 350,000 December 410,000 Historically, the cash collection of sales have been as follows: 65 percent in month of sale 25 percent in month following sale 8 percent in second month following sale 2 percent uncollectible The company allows a 2 percent cash discount for payments made by customers during the month of the sale. July and August sales were $405,000 and $275,000,...
Lee Company provides the following data for the months of July through October: Month                            
Lee Company provides the following data for the months of July through October: Month                                     Sales                             Purchases July                                         $180,000                      $105,000 August                                    165,000                      120,000 September                             150,000                          90,000 October                                  195,000                      135,000 Collections from customers are normally 70% in the month of sale and 30% in the following month. All purchases are on credit and paid in cash in the following month. November sales are budgeted to be $165,000, and November purchases are forecast to be $150,000. Cash disbursements for expenses in November...
ABC Company was organized on August 1 of the current year. Projected sales for the next...
ABC Company was organized on August 1 of the current year. Projected sales for the next three months are as follows: August   $250,000 September     200,000 October     275,000 The company expects to sell 50% of its merchandise for cash. Of the sales on account, 30% are expected to be collected in the month of the sale and the remainder in the following month. Prepare a schedule indicating cash collections for August, September, and October. ABC Company Schedule of Collections from Sales...
Question 2(19 Marks) Franklin Products Limited manufactures and distributes a number of products to retailers. One...
Question 2 Franklin Products Limited manufactures and distributes a number of products to retailers. One of these products, Super-Stick, requires four kilograms of material D236 in the manufacture of each unit. The company is now planning raw materials needs for the third quarter—July, August, and September. Peak sales of Super-Stick occur in the third quarter of each year. To keep production and shipments moving smoothly, the company has the following inventory requirements: a. The finished goods inventory on hand at...
The management of Nicto Company plans to have an inventory at the end of each month...
The management of Nicto Company plans to have an inventory at the end of each month equal to 20% of the next month's sales. Budgeted sales in units over the next three months are 86,000 in October, 126,000 in November, and 106,000 in December. Budgeted production for November would be:
ABC Company makes and sells a single product. It requires 4 pounds of direct materials to...
ABC Company makes and sells a single product. It requires 4 pounds of direct materials to produce one unit of this product. Budgeted units to be produced for the next four months is given below: Budgeted Units to be Produced July ?????? units August 17,000 units September 44,000 units October 28,000 units The company wants to maintain monthly ending inventories of direct materials equal to 28% of the next month's production needs. The cost of direct materials is $3.25 per...
Miami Company makes and sells a single product. It requires 4 pounds of direct materials to...
Miami Company makes and sells a single product. It requires 4 pounds of direct materials to produce one unit of this product. Budgeted units to be produced for the next four months is given below: Budgeted Units to be Produced July ?????? units August 17,000 units September 44,000 units October 28,000 units The company wants to maintain monthly ending inventories of direct materials equal to 28% of the next month's production needs. The cost of direct materials is $3.25 per...
ABC Company makes and sells a single product. It requires 4 pounds of direct materials to...
ABC Company makes and sells a single product. It requires 4 pounds of direct materials to produce one unit of this product. Budgeted units to be produced for the next four months is given below: Budgeted Units to be Produced July ?????? units August 17,000 units September 44,000 units October 28,000 units The company wants to maintain monthly ending inventories of direct materials equal to 28% of the next month's production needs. The cost of direct materials is $3.25 per...
Problem 1. Capes Corporation has budgeted sale of its popular scooter as follows: Month Units Unit...
Problem 1. Capes Corporation has budgeted sale of its popular scooter as follows: Month Units Unit Price Budgeted sales June 20,000 $10 $200,000 July 40,000 $10 $400,000 August 50,000 $10 $500,000 September 30,000 $10 $300,000 October 60,000 $10 $600,000 From past experience, the company has learned that 40% of a month’s sale are collected in the month of sale, another 60% are collected in the month following the sale. Prepare a schedule of expected cash collections from sales for the...
Milo Company manufactures beach umbrellas. The company is preparing detailed budgets for the third quarter and...
Milo Company manufactures beach umbrellas. The company is preparing detailed budgets for the third quarter and has assembled the following information to assist in the budget preparation: a.The Marketing Department has estimated sales as follows for the remainder of the year (in units): The selling price of the beach umbrellas is $12 per unit. July 40,500 October 30,500 August 91,000 November 17,000 September 60,000 December 17,500 b. All sales are on account. Based on past experience, sales are collected in...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT