FINANCIAL ACCOUNTING
10th Edition
ISBN: 9781259964947
Author: Libby
Publisher: MCG
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Preparing a Production Budget
Patrick Inc. makes industrial solvents. In the first 4 months of the coming year, Patrick expects the following unit sales:
January | 41,000 |
February | 38,000 |
March | 50,000 |
April | 51,000 |
Patrick's policy is to have 25% of next month's sales in ending inventory. On January 1, it is expected that there will be 4,500 drums of solvent on hand.
Required:
Prepare a production budget for the first quarter of the year. Show the number of drums that should be produced each month as well as for the quarter in total. If required, round your answers to the nearest whole unit.
Patrick Inc. | ||||
Production Budget | ||||
For the Coming Quarter | ||||
January | February | March | 1st Quarter Total | |
Sales | fill in the blank 1 | fill in the blank 2 | fill in the blank 3 | fill in the blank 4 |
Desired ending inventory | fill in the blank 5 | fill in the blank 6 | fill in the blank 7 | fill in the blank 8 |
Total needs | fill in the blank 9 | fill in the blank 10 | fill in the blank 11 | fill in the blank 12 |
Less: Beginning inventory | fill in the blank 13 | fill in the blank 14 | fill in the blank 15 | fill in the blank 16 |
Units to be produced | fill in the blank 17 | fill in the blank 18 | fill in the blank 19 | fill in the blank 20 |
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution
Trending nowThis is a popular solution!
Step by stepSolved in 2 steps with 1 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- Preparing a Sales Budget Patrick Inc. sells industrial solvents in 5-gallon drums. Patrick expects the following units to be sold in the first 3 months of the coming year: January 41,000 February 38,000 March 50,000 The average price for a drum is $37. Required: Prepare a sales budget for the first 3 months of the coming year, showing units and sales revenue by month and in total for the quarter. Do not include a multiplication symbol as part of your answer. Patrick Inc. Sales Budget For the Coming Quarter January February March 1st Quarter Total Units Price 2$ Salesarrow_forwardMajan company has budgeted sales in units for the next five months as follows: June 5,400 units July 6,500 units August 7,000 units September 8,200 units October 4,800 units Past experience has shown that the ending inventory for each month should be equal to 10% of the next month's sales in units. The inventory on May 31 is 400 units. The company needs to prepare a Production Budget for the next five months. The total number of units to be produced in August is a. 7,120 units b. 7,420 units c. 7,170 units d. 8,520 units W Parrow_forwardDhapaarrow_forward
- Silver Company makes a product with peak sales in May of each year. Its sales budget for the second quarter is given below: April May June Total Budgeted sales (all on account) $300,000 $500,000 $200,000 $1,000,000 The company estimates 20% of a month's sales are collected in the month of sale, another 70% are collected in the month following sale, and the remaining 10% are collected in the second month following sale. Bad debts are negligible and can be ignored. February sales totaled $230, 000, and March sales totaled $260,000. Required: Prepare a schedule of expected cash collections from sales, by month and in total, for the second quarter. What is the accounts receivable balance on June 30th?arrow_forwardHow do I prepare the cash budget for the quarter ended March 31, 20X1?arrow_forwardBlue Wave Co. predicts the following unit sales for the coming four months: September, 3,300 units; October, 4,900 units; November, 6,700 units; and December, 7,900 units. The company's policy is to maintain finished goods inventory equal to 50% of the next month's sales. At the end of August, the company had 2,800 finished units on hand. Prepare a production budget for each of the months of September, October, and November. Blue Wave Co. Production Budget September, October and November September Next month's budgeted sales (units) Units to be produced % October % November %arrow_forward
- Dolson Appliances makes coffee machines for offices and homes. For next year, the production budget is 141,000 units. Beginning inventories will be 18,000 units and the desired ending inventory will be 16,000 units. Required: What is the sales budget for the coming year for Dolson Appliances? Sales budget unitsarrow_forwardLexi Company budgets unit sales of 1,510,000 in April, 1,210,000 in May, 320,000 in June, and 1,940,000 in July. Beginning inventory on April 1 is 604,000 units, and the company wants to have 40% of next month's unit sales in inventory at the end of each month. The merchandise cost per unit is $0.50. Prepare a merchandise purchases budget for the months of April, May, and June. LEXI COMPANY Merchandise Purchases Budget April May June Next period budgeted sales units Ratio of inventory to future sales Total required units Units to purchase Cost per unit Cost of merchandise purchases $ $ $arrow_forwardAtlantic Surf manufactures surfboards. The company's budgeted sales units for the next three months is shown below. Company policy is to maintain finished goods Inventory equal (in units) to 40% of the next month's unit sales. As of June 30, the company has 1,600 finished surfboards In Inventory. Budgeted sales units July 4,000 August 5,500 September 4,200 Prepare the production budget for the months of July and August. ATLANTIC SURF Production Budget Desired ending inventory units Total required units Units to be produced July Augustarrow_forward
- Silver Company makes a product with peak sales in May of each year. Its sales budget for the second quarter is given below: Budgeted sales (all on account) April $300,000 May $500,000 June $200,000 Total $1,000,000 The company estimates 20% of a month's sales are collected in the month of sale, another 70% are collected in the month following sale, and the remaining 10% are collected in the second month following sale. Bad debts are negligible and can be ignored. February sales totaled $230,000, and March sales totaled $260,000. Required: 1. Prepare a schedule of expected cash collections from sales, by month and in total, for the second quarter. 2. What is the accounts receivable balance on June 30th? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Prepare a schedule of expected cash collections from sales, by month and in total, for the second quarter. Schedule of Expected Cash Collections February sales March sales April sales May sales June…arrow_forwardFact Pattern: A company produces a product that requires 2 pounds of a raw material. It is forecast that there will be 6,000 pounds of raw material on hand at the end of June. At the end of any given month, the company wishes to have 30% of next month's raw material requirements on hand. The company has budgeted production of the product for July, August, September, and October to be 10,000, 12,000, 13,000, and 11,000 units, respectively. As of June 1, the raw material sells for $1.00 per pound. In the month of September, raw material purchases and ending inventory, respectively, will be (in pounds): OA. OB. O C. 24,800 and 6,600. 32,600 and 6,600. 24,800 and 3,900. OD. 13,000 and 3,900.arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON
Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education