Managerial Accounting 6691, Business & Finance Homework Help

  

ACT 6691
Managerial Accounting
Budget Project and Basis for Presentation
In this case a full set of budgets will be prepared and
presented in appropriate format.  Reports
will be prepared to explain how budget numbers were determined.  The following are general requirements for
this budget case.  Specific requirements
are listed after the relevant case data. 

· 
Read the case and analyze the information.
· 
Prepare an operating budget in standard “income
statement” format. 
· 
Prepare a narrative report (or notes to the
income statement) addressing why/how quantitative items were selected.  The following items must be explained:
1. 
Sales Forecast
2. 
Purchases budget (raw materials, labor, all
resources)
3. 
Operating Expenses 
· 
Prepare a cash budget using any acceptable
format.  The following items must be
explained or shown on the budget:
1. 
The process by which cash inflows were
projected.
2. 
The process by which cash outflows were
projected.
3. 
The process by which financing, if applicable,
was determined.
4. 
How interest and other financing charges were
calculated.
· 
Prepare a capital budget using any acceptable
format.
You will be graded on your understanding of the underlying
concepts related to determining budget amounts (for example, how purchases are
determined) as well as your ability to prepare and explain standard business
reports.  The rubric attached as the last
page of this document will be used to grade the case. 
Harvey’s
Budget1
Harvey Manufacturing manufactures and sells two industrial
products:  a self-balancing screw driver
and a self-balancing saw.  Both products
are manufactured in a single plant. 
Harvey’s general manager, Mr. Lipscomb, and president, Mr.
Owens, want a budget prepared for each quarter of the fiscal year 2013.  They have asked various employees to gather
information that they believe will be necessary for preparation of a
budget.  The information is presented
below. 
Neither Mr. Lipscomb nor Mr. Owens is skilled in budget
preparation.  Both executives have used
budgets and have participated to some degree in budget preparation in prior
years, but neither has prepared a full budget. 

Don't use plagiarized sources. Get Your Custom Essay on
Managerial Accounting 6691, Business & Finance Homework Help
Just from $10/Page
Order Essay

Sales in units and selling price (SP) in dollars per unit
Historical sales for 2012 for each of the two products are
shown below. 
 
Harvey’s sales typically peak in the summer months,
beginning with May.  Harvey’s general
manager, Mr. Lipscomb, recommends that the budget be prepared with the units
sold in the high sales months of May, June, and July be used as the bases for
determining the annual forecast.  Mr.
Lipscomb’s recommendation is that annual sales be budgeted at 64,000 units per
month for screwdrivers and 42,000 units per month for saws. 
Mr. Lipscomb also believes that the budgeted selling price
per unit should be equal to the highest selling price that could be achieved in
2012.  He would like to budget $102 per
unit for screwdrivers and $130 per unit for saws.  Mr. Lipscomb states that his management team experimented
with pricing in the prior year, beginning with the first month of the year.
You review the unit sales and unit selling price information
for 2012 and recommend a budget based on 60,000 units of screwdrivers at $100
each and 40,000 units of saws at $125 each. 
Mr. Lipscomb challenges your conclusion.  Likewise Mr. Owens, the company president,
would like to hear an explanation of the budget numbers and how or why you
calculated those numbers. 
Production Requirements
Each unit produced requires the following materials, labor,
and overhead, all of which is variable. 
The company applies variable overhead on the basis of direct labor
hours. 

Inventories
Inventories are listed below.  The beginning inventories are the actual
amounts on hand at the beginning of the year. 
The ending inventories shown are the amounts that the operations manager
has determined to be necessary to ensure smooth production processes in the
following quarter. 

Other information
  Fixed manufacturing overhead
Fixed manufacturing overhead is
$214,000, including $156,000 of non-cash expenditures.
Fixed manufacturing overhead is
allocated on total units produced.
Beginning cash is $1,800,000.
Sales are on credit.  Sales are collected 50 percent in the current
period and the remainder in the next period. 
There are no bad debts. 
Sales for the last quarter were
$8,400,000. 
Purchases for direct materials and
labor costs are paid for in the quarter acquired.
Manufacturing overhead expenses are
paid in the quarter incurred. 
Selling and administrative expenses
are all fixed and are paid in the quarter incurred.
Estimated selling and
administrative expenses for the next period are $340,000 per quarter, including
$90,000 of depreciation. 
REQUIREMENTS:
FOR THE FIRST QUARTER OF 2013:
1.    Prepare a sales budget in good form.
2.  Prepare a narrative report explaining how your sales budget was
determined.  Use the table above in your
analysis.  (Hint:  Many companies would develop their budgets
using average sales and average unit costs.) 

Whatever budget determination
method you use should be explained.  In
your explanation, you should include a discussion of why you believe sales and
selling prices fluctuated last year. 
3.    Prepare a production budget in units.
4.    Prepare
a purchases budget.  Remember that you
will need to purchase enough materials to have the required ending inventories
shown.  You will also need to purchase
enough to manufacture and sell the products on your sales forecast.  Do not forget that you have beginning inventories. 
5.  Prepare a narrative report explaining how you prepared the purchases
budget.  Be as detailed as necessary to
be sure that the president and general manager will understand the calculations
and costs.
6.    Prepare
a manufacturing cost budget
Optional:  Prepare a budgeted
income statement. 
7.  Prepare a contribution margin income
statement.
8.  Prepare a narrative report explaining how the expenses on the income
statement were determined. 
9.  Prepare a cash budget.  Be sure that you show all cash inflows and
outflows. 
10.  Prepare a narrative report explaining your cash budget process.
11.  If necessary, prepare a capital
expenditure budget.  Explain your entries.  Use
only the facts in this case to prepare the budget. 
Summary:
Your finished  case
will consist of six or seven budgets (a sales budget, a production budget in
units, a purchases budget, a budgeted income statement, a contribution margin
income statement, a cash budget, and, if necessary, a capital expenditure
budget.) 
You will also have four or five narrative reports (a sales
budget report, a purchases budget report, an income statement report, a cash
budget report, and an explanation of your capital budget, if necessary).
Narrative reports are reports that are in the form or a
white paper that clearly explains the numeric entries on your budgets.  The length of the narrative reports will
depend on the particular report.  In
general, you should be able to prepare the sales budget report on one or two
pages, the purchases budget report on one or two pages, the income statement
report on one page, and the cash budget report on one page.  In this case, the capital budget report would
be less than one page.  You should not
worry if one of your reports is more or less than the recommendation given
here—just be sure you cover all of the important points and satisfactorily
explain the numeric entries in your budget. 
Also, be sure you explain the process of “how” your numbers were determined.  In this regard, it is not necessary or
desirable to explain the exact calculations. 
Consider your audience and prepare a report that would be suitable for
executives making plans and decisions for the upcoming year. 
1Harvey’s budget is adapted
from a published case.
act_6691_budget_project__1_.docx

Unformatted Attachment Preview

ACT 6691
Managerial Accounting
Budget Project and Basis for Presentation
In this case a full set of budgets will be prepared and presented in appropriate format. Reports will be
prepared to explain how budget numbers were determined. The following are general requirements
for this budget case. Specific requirements are listed after the relevant case data.





Read the case and analyze the information.
Prepare an operating budget in standard “income statement” format.
Prepare a narrative report (or notes to the income statement) addressing why/how quantitative
items were selected. The following items must be explained:
1. Sales Forecast
2. Purchases budget (raw materials, labor, all resources)
3. Operating Expenses
Prepare a cash budget using any acceptable format. The following items must be explained or
shown on the budget:
1. The process by which cash inflows were projected.
2. The process by which cash outflows were projected.
3. The process by which financing, if applicable, was determined.
4. How interest and other financing charges were calculated.
Prepare a capital budget using any acceptable format.
You will be graded on your understanding of the underlying concepts related to determining budget
amounts (for example, how purchases are determined) as well as your ability to prepare and explain
standard business reports. The rubric attached as the last page of this document will be used to grade
the case.
Harvey’s Budget1
Harvey Manufacturing manufactures and sells two industrial products: a self-balancing screw driver and
a self-balancing saw. Both products are manufactured in a single plant.
Harvey’s general manager, Mr. Lipscomb, and president, Mr. Owens, want a budget prepared for each
quarter of the fiscal year 2013. They have asked various employees to gather information that they
believe will be necessary for preparation of a budget. The information is presented below.
Neither Mr. Lipscomb nor Mr. Owens is skilled in budget preparation. Both executives have used
budgets and have participated to some degree in budget preparation in prior years, but neither has
prepared a full budget.
Sales in units and selling price (SP) in dollars per unit
Historical sales for 2012 for each of the two products are shown below.
January
February
March
April
May
June
July
August
September
October
November
December
Product Sales for 2012
Screwdriver
Saws
Units
SP
Units
SP
20,100
98
13,500
118
20,000
98
13,000
120
19,900
98
13,500
122
19,000
100
12,000
125
21,500
100
13,000
125
22,000
102
14,000
130
22,000
102
15,000
130
20,000
102
14,500
130
19,500
100
13,500
125
19,000
100
13,000
125
19,000
100
12,500
125
18,000
100
12,500
125
Harvey’s sales typically peak in the summer months, beginning with May. Harvey’s general manager,
Mr. Lipscomb, recommends that the budget be prepared with the units sold in the high sales months of
May, June, and July be used as the bases for determining the annual forecast. Mr. Lipscomb’s
recommendation is that annual sales be budgeted at 64,000 units per month for screwdrivers and
42,000 units per month for saws.
Mr. Lipscomb also believes that the budgeted selling price per unit should be equal to the highest selling
price that could be achieved in 2012. He would like to budget $102 per unit for screwdrivers and $130
per unit for saws. Mr. Lipscomb states that his management team experimented with pricing in the
prior year, beginning with the first month of the year.
You review the unit sales and unit selling price information for 2012 and recommend a budget based on
60,000 units of screwdrivers at $100 each and 40,000 units of saws at $125 each. Mr. Lipscomb
challenges your conclusion. Likewise Mr. Owens, the company president, would like to hear an
explanation of the budget numbers and how or why you calculated those numbers.
Production Requirements
Each unit produced requires the following materials, labor, and overhead, all of which is variable. The
company applies variable overhead on the basis of direct labor hours.
Standard costs per unit
Direct materials
Metal
Plastic
Handles
Direct labor
Variable manufacturing OH
Total
Screwdrivers
Units
Unit cost
5
lbs
8.00
3
lbs
5.00
1
unit
3.00
2
2
hrs
hrs
12.00
1.50
Cost
40.00
15.00
3.00
58.00
Units
4
3
24.00
3.00
85.00
3
3
lbs
lbs
Saws
Unit cost
8.00
5.00
Cost
32.00
15.00
47.00
hrs
hrs
16.00
1.50
48.00
4.50
99.50
Inventories
Inventories are listed below. The beginning inventories are the actual amounts on hand at the
beginning of the year. The ending inventories shown are the amounts that the operations manager has
determined to be necessary to ensure smooth production processes in the following quarter.
Inventories
Screwdrivers, finished
Saws, finished
Metal
Plastic
Handles
First Quarter
Beginning Ending
20,000
25,000
8,000
10,000
32,000
36,000
29,000
32,000
6,000
7,000
Other information
Fixed manufacturing overhead
Fixed manufacturing overhead is $214,000, including $156,000 of non-cash
expenditures.
Fixed manufacturing overhead is allocated on total units produced.
Beginning cash is $1,800,000.
Sales are on credit. Sales are collected 50 percent in the current period and the remainder in
the next period. There are no bad debts.
Sales for the last quarter were $8,400,000.
Purchases for direct materials and labor costs are paid for in the quarter acquired.
Manufacturing overhead expenses are paid in the quarter incurred.
Selling and administrative expenses are all fixed and are paid in the quarter incurred.
Estimated selling and administrative expenses for the next period are $340,000 per quarter,
including $90,000 of depreciation.
REQUIREMENTS:
FOR THE FIRST QUARTER OF 2013:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
Prepare a sales budget in good form.
Prepare a narrative report explaining how your sales budget was determined. Use the table
above in your analysis. (Hint: Many companies would develop their budgets using average sales
and average unit costs.)
Whatever budget determination method you use should be explained. In your explanation, you
should include a discussion of why you believe sales and selling prices fluctuated last year.
Prepare a production budget in units.
Prepare a purchases budget. Remember that you will need to purchase enough materials to
have the required ending inventories shown. You will also need to purchase enough to
manufacture and sell the products on your sales forecast. Do not forget that you have
beginning inventories.
Prepare a narrative report explaining how you prepared the purchases budget. Be as detailed
as necessary to be sure that the president and general manager will understand the calculations
and costs.
Prepare a manufacturing cost budget. Optional: Prepare a budgeted income statement.
Prepare a contribution margin income statement.
Prepare a narrative report explaining how the expenses on the income statement were
determined.
Prepare a cash budget. Be sure that you show all cash inflows and outflows.
Prepare a narrative report explaining your cash budget process.
If necessary, prepare a capital expenditure budget. Explain your entries. Use only the facts in
this case to prepare the budget.
Summary:
Your finished case will consist of six or seven budgets (a sales budget, a production budget in units, a
purchases budget, a budgeted income statement, a contribution margin income statement, a cash
budget, and, if necessary, a capital expenditure budget.)
You will also have four or five narrative reports (a sales budget report, a purchases budget report, an
income statement report, a cash budget report, and an explanation of your capital budget, if necessary).
Narrative reports are reports that are in the form or a white paper that clearly explains the numeric
entries on your budgets. The length of the narrative reports will depend on the particular report. In
general, you should be able to prepare the sales budget report on one or two pages, the purchases
budget report on one or two pages, the income statement report on one page, and the cash budget
report on one page. In this case, the capital budget report would be less than one page. You should not
worry if one of your reports is more or less than the recommendation given here—just be sure you
cover all of the important points and satisfactorily explain the numeric entries in your budget. Also, be
sure you explain the process of “how” your numbers were determined. In this regard, it is not necessary
or desirable to explain the exact calculations. Consider your audience and prepare a report that would
be suitable for executives making plans and decisions for the upcoming year.
1
Harvey’s budget is adapted from a published case.

Purchase answer to see full
attachment

Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

Order your essay today and save 30% with the discount code ESSAYSHELP