{"id":74690,"date":"2018-02-20T23:50:30","date_gmt":"2018-02-20T23:50:30","guid":{"rendered":"https:\/\/writemyessayfree.com\/acc-202-gso-budget-project"},"modified":"2017-08-18T06:46:48","modified_gmt":"2017-08-18T06:46:48","slug":"acc-202-gso-budget-project","status":"publish","type":"post","link":"https:\/\/www.benedictsol.com\/blogs\/acc-202-gso-budget-project\/","title":{"rendered":"ACC 202 \u2013 GSO Budget Project"},"content":{"rendered":"<p>The GSO Company manufactures and sells a high quality garden ornament (the<br \/> Guilford Gnome). The Gnome has one direct material Plaster of Paris. Other<br \/> materials, such as paint and lacquer are treated as indirect materials. GSO is preparing<br \/> budgets for the fourth quarter ending December 31, 2013. For each requirement<br \/> below prepare budgets by month for October, November and December and a total<br \/> budget for the quarter. Last year\u2019s sales (2012) for the corresponding period (plus<br \/> January and February 2013) were:<br \/> October<br \/> November<br \/> December<br \/> January<br \/> February<\/p>\n<p>5,000 gnomes<br \/> 8,000 gnomes<br \/> 15,000 gnomes<br \/> 10,000 gnomes<br \/> 5,000 gnomes<\/p>\n<p>The company expects the above number of gnome sales to increase by 10% for the<br \/> period Oct. 2013 Feb. 2014. The budgeted selling price for 2013\/14 is $149.00 per<br \/> gnome. The company expects 30% of its sales to be cash (COD) sales. The<br \/> remaining 70% of sales will be made on credit. Prepare a Sales Budget for GSO.<br \/> 2.<\/p>\n<p>The company desires to have finished goods inventory on hand at the end of each<br \/> month equal to 5 percent of the following month\u2019s budgeted unit sales. On September<br \/> 30, 2013, there were 275 gnomes on hand. Prepare a Production budget.<\/p>\n<p>3.<\/p>\n<p>Ten pounds of material are required per gnome. Management desires to have<br \/> materials on hand at the end of each month equal to 20 percent of the following<br \/> month\u2019s production needs. The beginning materials inventory, October 2013, was<br \/> 11,330 pounds. The material costs $4.00 per pound. Prepare a Direct Materials<br \/> budget.<\/p>\n<p>4.<\/p>\n<p>Each gnome produced requires 0.75 hours of direct labor. Each hour of direct labor<br \/> costs the company $18. Prepare a Direct Labor budget.<\/p>\n<p>5.<\/p>\n<p>Variable manufacturing overhead (MOH) is allocated at the rate of $12 per direct<br \/> labor hour. That is, for each budgeted direct labor hour, allocate $12 of variable<br \/> MOH. Fixed manufacturing overhead is $240,000 per month. Prepare a<br \/> Manufacturing Overhead budget.<\/p>\n<p>6.<\/p>\n<p>Variable selling and administrative expenses are $8.00 per gnome sold. Fixed selling<br \/> and administrative expenses are $120,000 per month. Prepare an Operating<br \/> Expenses budget.<\/p>\n<p>7.<\/p>\n<p>Prepare a Budgeted Manufacturing Cost per unit budget. The total production<br \/> volume for the year is budgeted as 96,000 gnomes. HINT: refer back to step 5. To<br \/> calculate the VMOH\/unit cost you should use the variable overhead rate times the<br \/> allocation base. To calculate FMOH\/unit calculate total FMOH for the year and<br \/> divide this by budgeted production for the year: refer to footnote d on page 527 of<br \/> the textbook.<\/p>\n<p>8.<\/p>\n<p>Prepare a Budgeted Income Statement for the quarter for GSO. Assume interest<br \/> expense of $0, and income tax expense of 35% of income before taxes.<\/p>\n<p>Directions:<br \/> Refer to Chapter 9 (The Master Budget) for guidance in setting up your budgets and<br \/> schedules. Adapt your schedules for the specific details outlined in the requirements<br \/> above. Prepare your budgets using Excel. Use formulas and cell references so that any<br \/> change you make in one budget is carried through to all the budgets (there should be<br \/> no hard keyed numbers in your formulas). For example, if you change the sales volume<br \/> increase from 10% to 20% you should see effects of that change throughout the other<br \/> budgets. Likewise, if the budgeted selling price changes from $149 to $145 your<br \/> spreadsheet model should be able to quickly and easily accommodate this change, i.e.,<br \/> change the input cell for budgeted selling price and see the effect on income.<br \/> The spreadsheet will be graded on presentation, completeness, correctness, and quality of<br \/> your spreadsheet model (i.e., does it update correctly for changes in input variables). You<br \/> should approach this assignment as if you are the Cost Accountant at the GSO Company<br \/> and you are going to present these budgets in a meeting to the CEO, CFO, and other<br \/> management personnel.<br \/> Some general principles to follow in constructing your excel spreadsheet model:<br \/> 1. Prepare an input area in which you enter all input variables e.g., selling price,<br \/> budgeted volume increase, pounds per gnome, ending inventory percentage, etc<br \/> 2. Each schedule should refer to the input area to source data (see sample<br \/> spreadsheet file). If possible, keep all constant values together in one area of the<br \/> worksheet. An important principle of good spreadsheet design is to keep just one<br \/> copy of each constant value. That is, enter a constant value in only one location in<br \/> the worksheet. Then if you use the value in another cell, use a cell reference that<br \/> refers to the constant value\u2019s unique location.<br \/> Example: You enter the constant value of 6% for sales tax in cell E5.<br \/> When you write a formula in your worksheet that requires sales tax,<br \/> reference E5 in the formula instead of &amp;quot;hard coding&amp;quot; in the 6% value.<br \/> Do: =subtotal*E5<br \/> Don\u2019t: =subtotal*6%<\/p>\n<p>There should be no hard-keyed numbers in your formulas e.g., the formula to<br \/> determine current period sales in units should reference last years sales volume<br \/> and a cell with the volume percentage increase.<br \/> 4. Label and format appropriately e.g., use $ to format dollar amounts, format cells<br \/> for decimal places, etc<br \/> 3.<\/p>\n<p>Submit your Excel spreadsheet to me by email. Include your name in the spreadsheet and<br \/> in the filename.<br \/> Email me if you have any questions. This is to be your OWN work. If I consider files<br \/> have been copied and you are submitting the work of another student I will assign zero<br \/> for the assignment. Late work will not be accepted.<i><\/i><\/p>\n","protected":false},"excerpt":{"rendered":"<p>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 <a href=\"https:\/\/www.benedictsol.com\/blogs\/acc-202-gso-budget-project\/\" class=\"read-more\">Read More &#8230;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-74690","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/74690","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/comments?post=74690"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/74690\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=74690"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=74690"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=74690"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}