ACC 202 – GSO Budget Project

The GSO Company manufactures and sells a high quality garden ornament (the
Guilford Gnome). The Gnome has one direct material Plaster of Paris. Other
materials, such as paint and lacquer are treated as indirect materials. GSO is preparing
budgets for the fourth quarter ending December 31, 2013. For each requirement
below prepare budgets by month for October, November and December and a total
budget for the quarter. Last year’s sales (2012) for the corresponding period (plus
January and February 2013) were:
October
November
December
January
February

5,000 gnomes
8,000 gnomes
15,000 gnomes
10,000 gnomes
5,000 gnomes

The company expects the above number of gnome sales to increase by 10% for the
period Oct. 2013 Feb. 2014. The budgeted selling price for 2013/14 is $149.00 per
gnome. The company expects 30% of its sales to be cash (COD) sales. The
remaining 70% of sales will be made on credit. Prepare a Sales Budget for GSO.
2.

The company desires to have finished goods inventory on hand at the end of each
month equal to 5 percent of the following month’s budgeted unit sales. On September
30, 2013, there were 275 gnomes on hand. Prepare a Production budget.

3.

Ten pounds of material are required per gnome. Management desires to have
materials on hand at the end of each month equal to 20 percent of the following
month’s production needs. The beginning materials inventory, October 2013, was
11,330 pounds. The material costs $4.00 per pound. Prepare a Direct Materials
budget.

4.

Each gnome produced requires 0.75 hours of direct labor. Each hour of direct labor
costs the company $18. Prepare a Direct Labor budget.

5.

Variable manufacturing overhead (MOH) is allocated at the rate of $12 per direct
labor hour. That is, for each budgeted direct labor hour, allocate $12 of variable
MOH. Fixed manufacturing overhead is $240,000 per month. Prepare a
Manufacturing Overhead budget.

6.

Variable selling and administrative expenses are $8.00 per gnome sold. Fixed selling
and administrative expenses are $120,000 per month. Prepare an Operating
Expenses budget.

7.

Prepare a Budgeted Manufacturing Cost per unit budget. The total production
volume for the year is budgeted as 96,000 gnomes. HINT: refer back to step 5. To
calculate the VMOH/unit cost you should use the variable overhead rate times the
allocation base. To calculate FMOH/unit calculate total FMOH for the year and
divide this by budgeted production for the year: refer to footnote d on page 527 of
the textbook.

8.

Prepare a Budgeted Income Statement for the quarter for GSO. Assume interest
expense of $0, and income tax expense of 35% of income before taxes.

Directions:
Refer to Chapter 9 (The Master Budget) for guidance in setting up your budgets and
schedules. Adapt your schedules for the specific details outlined in the requirements
above. Prepare your budgets using Excel. Use formulas and cell references so that any
change you make in one budget is carried through to all the budgets (there should be
no hard keyed numbers in your formulas). For example, if you change the sales volume
increase from 10% to 20% you should see effects of that change throughout the other
budgets. Likewise, if the budgeted selling price changes from $149 to $145 your
spreadsheet model should be able to quickly and easily accommodate this change, i.e.,
change the input cell for budgeted selling price and see the effect on income.
The spreadsheet will be graded on presentation, completeness, correctness, and quality of
your spreadsheet model (i.e., does it update correctly for changes in input variables). You
should approach this assignment as if you are the Cost Accountant at the GSO Company
and you are going to present these budgets in a meeting to the CEO, CFO, and other
management personnel.
Some general principles to follow in constructing your excel spreadsheet model:
1. Prepare an input area in which you enter all input variables e.g., selling price,
budgeted volume increase, pounds per gnome, ending inventory percentage, etc
2. Each schedule should refer to the input area to source data (see sample
spreadsheet file). If possible, keep all constant values together in one area of the
worksheet. An important principle of good spreadsheet design is to keep just one
copy of each constant value. That is, enter a constant value in only one location in
the worksheet. Then if you use the value in another cell, use a cell reference that
refers to the constant value’s unique location.
Example: You enter the constant value of 6% for sales tax in cell E5.
When you write a formula in your worksheet that requires sales tax,
reference E5 in the formula instead of "hard coding" in the 6% value.
Do: =subtotal*E5
Don’t: =subtotal*6%

There should be no hard-keyed numbers in your formulas e.g., the formula to
determine current period sales in units should reference last years sales volume
and a cell with the volume percentage increase.
4. Label and format appropriately e.g., use $ to format dollar amounts, format cells
for decimal places, etc
3.

Submit your Excel spreadsheet to me by email. Include your name in the spreadsheet and
in the filename.
Email me if you have any questions. This is to be your OWN work. If I consider files
have been copied and you are submitting the work of another student I will assign zero
for the assignment. Late work will not be accepted.

Previous answers to this question


This is a preview of an assignment submitted on our website by a student. If you need help with this question or any assignment help, click on the order button below and get started. We guarantee authentic, quality, 100% plagiarism free work or your money back.

order uk best essays Get The Answer
Uncategorized

Leave a Reply

Your email address will not be published. Required fields are marked *

ACC 202 – GSO Budget Project

The GSO Company manufactures and sells a high quality garden ornament (the
Guilford Gnome). The Gnome has one direct material Plaster of Paris. Other
materials, such as paint and lacquer are treated as indirect materials. GSO is preparing
budgets for the fourth quarter ending December 31, 2013. For each requirement
below prepare budgets by month for October, November and December and a total
budget for the quarter. Last year’s sales (2012) for the corresponding period (plus
January and February 2013) were:
October
November
December
January
February

5,000 gnomes
8,000 gnomes
15,000 gnomes
10,000 gnomes
5,000 gnomes

The company expects the above number of gnome sales to increase by 10% for the
period Oct. 2013 Feb. 2014. The budgeted selling price for 2013/14 is $149.00 per
gnome. The company expects 30% of its sales to be cash (COD) sales. The
remaining 70% of sales will be made on credit. Prepare a Sales Budget for GSO.
2.

The company desires to have finished goods inventory on hand at the end of each
month equal to 5 percent of the following month’s budgeted unit sales. On September
30, 2013, there were 275 gnomes on hand. Prepare a Production budget.

3.

Ten pounds of material are required per gnome. Management desires to have
materials on hand at the end of each month equal to 20 percent of the following
month’s production needs. The beginning materials inventory, October 2013, was
11,330 pounds. The material costs $4.00 per pound. Prepare a Direct Materials
budget.

4.

Each gnome produced requires 0.75 hours of direct labor. Each hour of direct labor
costs the company $18. Prepare a Direct Labor budget.

5.

Variable manufacturing overhead (MOH) is allocated at the rate of $12 per direct
labor hour. That is, for each budgeted direct labor hour, allocate $12 of variable
MOH. Fixed manufacturing overhead is $240,000 per month. Prepare a
Manufacturing Overhead budget.

6.

Variable selling and administrative expenses are $8.00 per gnome sold. Fixed selling
and administrative expenses are $120,000 per month. Prepare an Operating
Expenses budget.

7.

Prepare a Budgeted Manufacturing Cost per unit budget. The total production
volume for the year is budgeted as 96,000 gnomes. HINT: refer back to step 5. To
calculate the VMOH/unit cost you should use the variable overhead rate times the
allocation base. To calculate FMOH/unit calculate total FMOH for the year and
divide this by budgeted production for the year: refer to footnote d on page 527 of
the textbook.

8.

Prepare a Budgeted Income Statement for the quarter for GSO. Assume interest
expense of $0, and income tax expense of 35% of income before taxes.

Directions:
Refer to Chapter 9 (The Master Budget) for guidance in setting up your budgets and
schedules. Adapt your schedules for the specific details outlined in the requirements
above. Prepare your budgets using Excel. Use formulas and cell references so that any
change you make in one budget is carried through to all the budgets (there should be
no hard keyed numbers in your formulas). For example, if you change the sales volume
increase from 10% to 20% you should see effects of that change throughout the other
budgets. Likewise, if the budgeted selling price changes from $149 to $145 your
spreadsheet model should be able to quickly and easily accommodate this change, i.e.,
change the input cell for budgeted selling price and see the effect on income.
The spreadsheet will be graded on presentation, completeness, correctness, and quality of
your spreadsheet model (i.e., does it update correctly for changes in input variables). You
should approach this assignment as if you are the Cost Accountant at the GSO Company
and you are going to present these budgets in a meeting to the CEO, CFO, and other
management personnel.
Some general principles to follow in constructing your excel spreadsheet model:
1. Prepare an input area in which you enter all input variables e.g., selling price,
budgeted volume increase, pounds per gnome, ending inventory percentage, etc
2. Each schedule should refer to the input area to source data (see sample
spreadsheet file). If possible, keep all constant values together in one area of the
worksheet. An important principle of good spreadsheet design is to keep just one
copy of each constant value. That is, enter a constant value in only one location in
the worksheet. Then if you use the value in another cell, use a cell reference that
refers to the constant value’s unique location.
Example: You enter the constant value of 6% for sales tax in cell E5.
When you write a formula in your worksheet that requires sales tax,
reference E5 in the formula instead of "hard coding" in the 6% value.
Do: =subtotal*E5
Don’t: =subtotal*6%

There should be no hard-keyed numbers in your formulas e.g., the formula to
determine current period sales in units should reference last years sales volume
and a cell with the volume percentage increase.
4. Label and format appropriately e.g., use $ to format dollar amounts, format cells
for decimal places, etc
3.

Submit your Excel spreadsheet to me by email. Include your name in the spreadsheet and
in the filename.
Email me if you have any questions. This is to be your OWN work. If I consider files
have been copied and you are submitting the work of another student I will assign zero
for the assignment. Late work will not be accepted.

Previous answers to this question


This is a preview of an assignment submitted on our website by a student. If you need help with this question or any assignment help, click on the order button below and get started. We guarantee authentic, quality, 100% plagiarism free work or your money back.

order uk best essays Get The Answer
Uncategorized

Leave a Reply

Your email address will not be published. Required fields are marked *