Alger Inc. manufactures six models of leaf blowers and weed eaters. Alger's budgeting team is finalizing the sales budget for the coming year. Sales in units and dollars for last year follow: Product Number Sold Price ($) Revenue LB-1 14,700   32 $ 470,400 LB-2 18,000   20 360,000 WE-6 25,200   15 378,000 WE-7 16,200   10 162,000 WE-8 6,900   18 124,200 WE-9 4,000   22 88,000 Total       $1,582,600 In looking over the previous year's sales figures, Alger's sales budgeting team recalled the following: Model LB-1 is a newer version of the leaf blower with a gasoline engine. The LB-1 is mounted on wheels instead of being carried. This model is designed for the commercial market and did better than expected in its first year. As a result, the number of units of Model LB-1 to be sold was forecast at 325% of the previous year's units. Models WE-8 and WE-9 were introduced on July 1 of last year. They are lighter versions of the traditional weed eater and are designed for smaller households or condo units. Alger estimates that demand for both models will continue at the previous year's rate. A competitor has announced plans to introduce an improved version of model WE-6, Alger's traditional weed eater. Alger believes that the model WE-6 price must be cut 35% to maintain unit sales at the previous year's level. It was assumed that unit sales of all other models would increase by 8%, prices remaining constant. Required: Prepare a sales budget by product and in total for Alger Inc. for the coming year. Do not include a multiplication symbol as part of your answer.   Alger Inc. Sales Budget For the Coming Year Model Units Price Total Sales LB-1 fill in the blank 1 $fill in the blank 2 $fill in the blank 3 LB-2 fill in the blank 4 fill in the blank 5 fill in the blank 6 WE-6 fill in the blank 7 fill in the blank 8 fill in the blank 9 WE-7 fill in the blank 10 fill in the blank 11 fill in the blank 12 WE-8 fill in the blank 13 fill in the blank 14 fill in the blank 15 WE-9 fill in the blank 16 fill in the blank 17 fill in the blank 18 Total     $fill in the blank 19

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Question

Alger Inc. manufactures six models of leaf blowers and weed eaters. Alger's budgeting team is finalizing the sales budget for the coming year. Sales in units and dollars for last year follow:

Product Number Sold Price ($) Revenue
LB-1 14,700   32 $ 470,400
LB-2 18,000   20 360,000
WE-6 25,200   15 378,000
WE-7 16,200   10 162,000
WE-8 6,900   18 124,200
WE-9 4,000   22 88,000
Total       $1,582,600

In looking over the previous year's sales figures, Alger's sales budgeting team recalled the following:

  1. Model LB-1 is a newer version of the leaf blower with a gasoline engine. The LB-1 is mounted on wheels instead of being carried. This model is designed for the commercial market and did better than expected in its first year. As a result, the number of units of Model LB-1 to be sold was forecast at 325% of the previous year's units.
  2. Models WE-8 and WE-9 were introduced on July 1 of last year. They are lighter versions of the traditional weed eater and are designed for smaller households or condo units. Alger estimates that demand for both models will continue at the previous year's rate.
  3. A competitor has announced plans to introduce an improved version of model WE-6, Alger's traditional weed eater. Alger believes that the model WE-6 price must be cut 35% to maintain unit sales at the previous year's level.
  4. It was assumed that unit sales of all other models would increase by 8%, prices remaining constant.

Required:

Prepare a sales budget by product and in total for Alger Inc. for the coming year. Do not include a multiplication symbol as part of your answer.

 

Alger Inc.
Sales Budget
For the Coming Year
Model Units Price Total Sales
LB-1 fill in the blank 1 $fill in the blank 2 $fill in the blank 3
LB-2 fill in the blank 4 fill in the blank 5 fill in the blank 6
WE-6 fill in the blank 7 fill in the blank 8 fill in the blank 9
WE-7 fill in the blank 10 fill in the blank 11 fill in the blank 12
WE-8 fill in the blank 13 fill in the blank 14 fill in the blank 15
WE-9 fill in the blank 16 fill in the blank 17 fill in the blank 18
Total     $fill in the blank 19

 

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Budgeting
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
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education