ACC 302 Final ProjectProject Orientation and OverviewEvery year at the state fair your parents have run a pretzel booth. Over the years you have experimented with new pretzelrecipes and many have been successfully incorporated into the selection of pretzels now offered each year at the statefair.Your parents are ready to retire and turn the business over in your name. You want to capitalize on your parents successand expand by offering pretzels at a store location. In order to expand you will need to secure a bank loan to coverexpansion costs and overhead. To consider your proposal the banker will want to see a business plan specifically amaster budget.Your task for this final project is to prepare and present all the necessary documents so that you can ask for that loan.This task is broken down into four parts: Part 1: Mission Statement and Partial Business Plan due at the end of Week Five Part 2: Budgets Financial Statements and Analysis due at the end of Week Six Part 3: Complete Business Plan and Cover Letter due at the end of Week Seven Part 3: Business Plan Presentation due on Day 1 of Week EightPart 1 Mission Statement and Partial Business Plan due Week Five Review the following chapters:o Chapter 18: The Changing Business Environment: A Manager s Perspectiveo Chapter 19: Cost Concepts and Cost Allocationo Chapter 23: Cost Behavior Analysis Complete the Mission Statement Template Handout to record information about your pretzel company its missionand its featured product. Use the tables and information in Exhibit 1 on the next page to calculate the costs of running your business and tocomplete the short answer section of the Mission Statement Template Handout.o Calculate total variable costs per dozen pretzels.o Calculate sales price per dozen pretzels using 120% markup on variable costs.o Calculate contribution margin per dozen pretzels.o Calculate breakeven point for the quarter (three months) in dollars and units. Submit the completed Mission Statement Template Handout to My Assignments in My West.Exhibit 1:Cost of GoodsIf your pretzel recipe has ingredients that are not included here simply consider them part of your overhead expenses.Direct Materials Unit Unit CostFlour (any kind) per cup $ 0.15Sugar (any kind) per cup $ 0.15Dry Yeast per cup $ 0.501 Stick of Butter Shortening Oil per 1/2 cup $ 1.00Egg per cup $ 0.10Salt per 1/2 cup $ 0.75Specialty Ingredients (any kind e.g. chocolate chips cinnamoncheese pepperoni etc.)per cup $ 2.00Direct LaborInformation regarding direct labor cost is not maintained because your facility is highly automated. Direct labor is includedas part of manufacturing overhead.Manufacturing Overhead and Operating ExpensesManufacturing Overhead Variable(per dozen)Fixed(per month)Utilities $ 0.50Other Indirect Materials and Labor $ 0.75Maintenance $ 500.00Depreciation $ 2000.00Supervision $ 2500.00Totals $ 1.25 $ 5000.00Operating Expenses Variable(per dozen)Fixed(per month)Sales Commission $ 0.50Shipping Costs $ 1.00Salaries $ 5000.00Depreciation $ 200.00Other $ 1800.00Totals $ 1.50 $ 7000.00 ACC 302 Final Project 3 01/30/12Part 2 Budgets Financial Statements and Analysis due Week Six Review Chapter 24: The Budgeting Process. Use the tables and information presented in Exhibit 2 on the next page to determine production and financial budgetdata. Create a spreadsheet that provides the following budgets:o Sales budget/cash collections budgeto Direct materials purchases budget/cash disbursements budgeto Manufacturing overhead budgeto Operating expenses budget Create documents that show your projected income and your cash needs. More specifically use the budgets andother documentation that you have created for this project to create the following documents:o Proforma (projected) variable income statemento Proforma absorption income statemento Proforma balance sheeto Cash budget Respond to the following short answer questions using a word processing program:Discuss the importance of beginning the master budget process with an accurate sales budget.o What are some important factors that a manager should consider when developing a sales budget? State whyeach is important.o Distinguish between operating expenses and disbursements for operating expenses.o What is the main difference between the variable and absorption income statements?o What are the major benefits of budgeting? Submit the budgets financial documents and short answer questions to My Assignments in My West. ACC 302 Final Project 4 01/30/12Exhibit 2:Production Budget InformationIt is a few months before your store is opening. You expect to open the doors of your pretzel company as of January 1.You are starting fresh with no raw materials no accounts receivable and no accounts payable. You were able to secureseveral contracts with local businesses (i.e. sales associates that are paid on commission); based off these contractsyou were able to make projects for the first four months of the year. Because your pretzels are made fresh daily there is no work-in-process or finished goods inventory. You plan to maintain a raw direct material inventory of 10% of the next month production. Payment for raw direct materials is 25% in the month of purchase and 75% in the following months.Your monthly sales projections are based off your last name and sales are sold per dozen.Collections on SalesCash sales collected in the current month: 40%Credit sales are collected in the following month: 60%Financial Budget Information Your initial investment in your business is $50000 and you are looking to secure a bank loan for $50000 withadditional line of credit. However you must always have a minimum cash end-of-month balance of $10000. If there is any cash over $10000 available at the end of the month you must repay your outstanding balance in$1000 increments. If the end-of-month cash balance falls below $10000 you must make additional borrowing from the line of credit.These borrowings are also in increments of $1000. Your bank loan and line of credit has an annual interest rate of 12% which is paid monthly on the total outstandingborrowings at the end of the prior month.Additional Information: Fixed asset acquisition in January is $90000. Your income taxes are paid each quarter on net income at a rate of 25%.A-F G-L M-S T-ZJanuary 3750 2750 2000 1750February 3750 3250 3500 3750March 3750 4000 4500 3500April 3750 5000 5000 6000ACC 302 Final Project 5 01/30/12Part 3 Complete Business Plan and Cover Letter due Week Seven Write a cover letter to a banker explaining why the banker should approve your loan. Compile and complete your business plan including all supporting documentation created for this project. Submit your complete business plan as one document to My Assignments via My West.Part 4 Business Plan Presentation due in-class Week Eight Create a 5 15 slide Microsoft PowerPoint presentation of your business plan. The slides will be evaluated for:o Contento Relevanceo Layouto Readability Present your business plan in person (on campus) or via AdobeAcrobatConnectTM during the online classmeeting. Your presentation must be 10 15 minutes long (including Q & A) and will be evaluated on:o Delivery of the contento Answers to follow-up questions from the class and instructorFor online students: If you are to be absent from class your slides must include detailed speaker notes containing thecontent that would have been delivered in the live session.Note to instructor: Time devoted to final presentations may need to be adjusted to account for large class sizes. Theseadjustments are at the discretion of the instructor.