FINANCIAL ACCOUNTING
10th Edition
ISBN: 9781259964947
Author: Libby
Publisher: MCG
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Sales Budget
Assume that Stillwater Designs produces two automotive subwoofers: S12L7 and S12L5. The S12L7 sells for $627, and the S12L5 sells for $396. Projected sales (number of speakers) for the coming five quarters are as follows:
S12L7 | S12L5 | |
First quarter, 20Y1 | 800 | 1,300 |
Second quarter, 20Y1 | 2,200 | 1,400 |
Third quarter, 20Y1 | 5,600 | 5,300 |
Fourth quarter, 20Y1 | 4,600 | 3,900 |
First quarter, 20Y2 | 900 | 1,200 |
The vice president of sales believes that the projected sales are realistic and can be achieved by the company.
Required:
Prepare a sales budget for each quarter of 20Y1 and for the year in total. Show sales by product and in total for each time period. Do not include a multiplication symbol as part of your answer.
1st Qtr. | 2nd Qtr. | 3rd Qtr. | 4th Qtr. | Year | |
S12L7: | |||||
Units | fill in the blank 2f6b2604ff91fe0_1 | fill in the blank 2f6b2604ff91fe0_2 | fill in the blank 2f6b2604ff91fe0_3 | fill in the blank 2f6b2604ff91fe0_4 | fill in the blank 2f6b2604ff91fe0_5 |
Price | $fill in the blank 2f6b2604ff91fe0_6 | $fill in the blank 2f6b2604ff91fe0_7 | $fill in the blank 2f6b2604ff91fe0_8 | $fill in the blank 2f6b2604ff91fe0_9 | $fill in the blank 2f6b2604ff91fe0_10 |
Sales | $fill in the blank 2f6b2604ff91fe0_11 | $fill in the blank 2f6b2604ff91fe0_12 | $fill in the blank 2f6b2604ff91fe0_13 | $fill in the blank 2f6b2604ff91fe0_14 | $fill in the blank 2f6b2604ff91fe0_15 |
S12L5: | |||||
Units | fill in the blank 2f6b2604ff91fe0_16 | fill in the blank 2f6b2604ff91fe0_17 | fill in the blank 2f6b2604ff91fe0_18 | fill in the blank 2f6b2604ff91fe0_19 | fill in the blank 2f6b2604ff91fe0_20 |
Price | $fill in the blank 2f6b2604ff91fe0_21 | $fill in the blank 2f6b2604ff91fe0_22 | $fill in the blank 2f6b2604ff91fe0_23 | $fill in the blank 2f6b2604ff91fe0_24 | $fill in the blank 2f6b2604ff91fe0_25 |
Sales | $fill in the blank 2f6b2604ff91fe0_26 | $fill in the blank 2f6b2604ff91fe0_27 | $fill in the blank 2f6b2604ff91fe0_28 | $fill in the blank 2f6b2604ff91fe0_29 | $fill in the blank 2f6b2604ff91fe0_30 |
Total sales | $fill in the blank 2f6b2604ff91fe0_31 | $fill in the blank 2f6b2604ff91fe0_32 | $fill in the blank 2f6b2604ff91fe0_33 | $fill in the blank 2f6b2604ff91fe0_34 | $fill in the blank 2f6b2604ff91fe0_35 |
How will Stillwater Designs use this sales budget?
- Stillwater Designs will use the sales budget in planning as the basis for the production budget.
- The company can also compare actual sales against the budget to see if expectations were achieved.
- Both 1 and 2
- None of the above
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
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
- Mallory Company expects to sell 130 units in the first quarter, and 70 units in the second quarter. Assuming the company prefers to maintain finished goods inventory equal to 40% of the next quarter's sales, prepare a production budget for the first quarter only. Hint: This quarter's projected sales were used to determine last quarter's required ending inventory. Mallory Company Production Budget First Quarter Budgeted Sales in units Add: desired ending finished goods inventory Total finished goods inventory needed Deduct: beginning finished goods inventory Units to be produced 1st Qtr.arrow_forward1. WFU Corporation expects the unit sales of Product MSA to increase by 10%, while Product MA will increase by 5% of last year's sales. The company will increase the price of Product MSA by $10, while Product MA will remain the same. Prepare the budgeted revenue for the upcoming year, 20Y6 with the information below for 20Y5. Product MSA Product MA 2. WFU Corporation has a desired ending inventory of 5% of the upcoming year's sales for each year. In 20Y7, the company expects to sell 20,000 of Product MSA and 12,000 of Product MA. Prepare the company's production budget for 2016. 3. Each finished good of Product MSA and Product MA requires two materials, Product M and Product A, which are measured in pounds. Product M costs $7.50 per pound, and Product A costs $5.00 per pound. The required pounds of material per finished good and beginning and ending inventories are shown. Prepare the 20Y6 direct materials purchases budget. Product MSA Product MA Beginning inventory Ending inventory…arrow_forwardSales and Production Budgets Berring Company produces two products: the deluxe and the standard. The deluxe sells for $40, and the standard sells for $10. Projected sales of the two models for the coming four quarters are given below. Deluxe Standard First quarter 11,000 90,000 Second quarter 14,500 88,600 Third quarter 16,800 92,000 Fourth quarter 20,000 91,400 The president of the company believes that the projected sales are realistic and can be achieved by the company. In the factory, the production supervisor has received the projected sales figures and gathered information needed to compile production budgets. He found that 1,300 deluxes and 1,170 standards were in inventory on January 1. Company policy dictates that ending inventory should equal 20 percent of the next quarter’s sales for deluxes and 10 percent of next quarter’s sales for standards. Required: 1. Prepare a sales budget for each quarter and for the year in…arrow_forward
- Omegon Limited has the following sales forecasts for its watches next year:First Quarter..10,000 unitsSecond Quarter.5% increase over first quarterThird Quarter 3% increase from second quarterFourth Quarter.8% increase over third quarterWhat is Omegon’s total sales budget in units for next year?1) 43,485 units.2) 42,995 units.3) 40,685 units.4) 40,000 unitsarrow_forwardNavigator sells GPS trackers for $60 each. It expects sales of 5,200 units in quarter 1 and a 5% Increase each subsequent quarter for the next 8 quarters. Prepare a sales budget by quarter for the first year. Round final answers to nearest whole dollar. Navigator Sales Budget For the Year Ending Dec. 31, 20XX Quarter 1 Quarter 2 Quarter 3 Quarter 4 8 Expected Sales (Units) Sales Price per Unit Total Sales Revenue Totalarrow_forwardSales and Production Budgets Berring Company produces two products: the deluxe and the standard. The deluxe sells for $40, and the standard sells for $10. Projected sales of the two models for the coming four quarters are given below. Deluxe Standard First quarter 12,000 90,000 Second quarter 14,200 88,200 Third quarter 16,800 92,000 Fourth quarter 20,000 91,400 The president of the company believes that the projected sales are realistic and can be achieved by the company. In the factory, the production supervisor has received the projected sales figures and gathered information needed to compile production budgets. He found that 1,300 deluxes and 1,170 standards were in inventory on January 1. Company policy dictates that ending inventory should equal 20 percent of the next quarter’s sales for deluxes and 10 percent of next quarter’s sales for standards. Required: Question Content Area 1. Prepare a sales budget for each quarter…arrow_forward
- Surf Inc. has prepared the sales forecast as shown below: Description Month 1 Month 2 Month 3 Month 4 Sales Forecast 25,000.00 27,000.00 29,000.00 23,000.00 Prepare the production budget and show the required production for Months 1-3 Beg Inv Month 1 3,500.00 Required Ending Inventory 15% of the next months budgeted sales Description Month 1 Month 2 Month 3arrow_forwardThe marketing department of Kyle Corporation has submitted the following sales forecast for the upcoming fiscal year: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted sales (units) 8,800 10,800 12,800 11,800 The selling price of the company’s product is $28 per unit. Management expects to collect 60% of sales in the quarter in which the sales are made and 35% in the following quarter; 5% of sales are expected to be uncollectible. The beginning balance of accounts receivable, all of which are expected to be collected in the first quarter, is $88,500. The company expects to start the first quarter with 2,400 units in finished goods inventory. Management desires an ending finished goods inventory in each quarter equal to 15% of the next quarter’s budgeted sales. The desired ending finished goods inventory for the fourth quarter is 2,650 units. Required: 1-a. Prepare the company's sales budget. 1-b. Prepare the schedule of expected cash collections. 2.…arrow_forwardVaughn Chemicals has developed a new window cleaner that requires two ingredients, AM972 and CA38. Based on forecasted sales, Vaughn has developed the following budgeted production for the coming year. 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 1st QuarterNext Year Forecasted production (gallons) 5,000 7,000 9,000 12,500 6,000 Each gallon of window cleaner requires 100 ounces of AM972 and 28 ounces of CA38. An ounce of AM972 costs Vaughn $0.15. An ounce of CA38 costs the company $0.25. Vaughn's inventory policy requires ending inventory equal to 20% of the next quarter's production needs. At the beginning of the year, Vaughn expects to have 80,000 ounces of AM972 and 30,000 ounces of CA38 on hand.Prepare Vaughn's AM972 purchases budget for the coming year. (Enter price per ounce to 2 decimal places, e.g. 0.35.) 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Annual select an opening purchase…arrow_forward
- Give answer as per requiredarrow_forwardSo es AZ Products The marketing department of AZ Products has submitted the following sales forecast for the upcoming fiscal year: 1st Quarter Budgeted sales (units) 10,000 2nd Quarter 3rd Quarter 4th Quarter 9,000 6,000 8,000 The company is set to start the first quarter with an inventory of 3,200 units of finished goods. The goal is to maintain an ending inventory of finished goods each quarter that equals 20% of the next quarter's projected sales, with a target of 3,400 units for the end of the fourth quarter. The initial raw materials inventory for the first quarter is projected at 6,240 kilograms, and the starting accounts payable is estimated at $29,640. Each unit produced requires two kilograms of raw material, priced at $8 per kilogram. The company's objective is to conclude each quarter with raw material inventory that is 10% of the next quarter's production requirements, aiming for 6,280 kilograms by the end of the fourth quarter. Furthermore, the company intends to pay 75%…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