The picture is the question I need Only the second question on part 2.
B ACC 373 Group Project* Due Date: 6/7/21 *Adapted from “Tasty Cookies, Inc: A Mater Budget Case” by Thomas C. Wooten and Jane Dillard-Eggers INTRODUCTION You (and your group) are the owners of your own cookie company. It all started about three years ago when you began using your Grandma's cookie recipe to bake, what most people consider, the "best tasting cookies they have ever put in their mouth." At first, you started baking cookies as a little side business. You bake them right in your home and sell them to friends and local stores. Response has been great! People love the cookies, and you are making a little extra money. Your fast sales growth has negatives in addition to positives. The volume of business has grown so much that you can no longer keep up with demand. Your desire to grow this hobby into a full- fledged business has led you to explore expanding. You have been investigating new facilities and equipment, and checking into the requirements of hiring a few employees. However, there is one problem; you don't have the money to expand! On the advice of a friend, you meet with a local banker. You share your dreams and ideas, and your need to borrow some money. The banker is encouraging and helpful. However, she states that the bank cannot lend you any money without a business plan that describes your financial results, marketing strategy, and projections for the future. You show the banker your income statement and balance sheet as of the most recent year-end, and the banker is impressed! "Looks very promising," she states. "But what I really need to see is what you plan to do with the money that I will lend you and what your business will look like next year." When you return home after the meeting, you pull out your college accounting textbook. You realize that this is a master budget problem just like you did in your managerial accounting class. After reviewing your class notes and reading the textbook, you settle in to produce a plan for next year. WRITTEN ASSIGNMENT (150 points) PART 1: Product Costs You immediately realize that you must gain an understanding of your cost structure and of the relationship between your revenues, costs, and profits. You pull out Grandma’s recipe to see what ingredients it takes to make a dozen cookies. Next, you go to your invoice files to determine the cost of each of the ingredients. You brainstorm to develop a list of the new costs that you must incur when you expand your operations. After analyzing all of this data you are able to break out your costs into several categories. You realize that some costs are for raw materials while others are related to manufacturing overhead or (non-manufacturing) operating expenses. You also realize that some costs appear to be fixed while other costs are variable. Now you have sufficient information to determine how much money you can make when you sell these cookies. Requirements for Part 1: 1. As a group, think of your favorite cookie. Search the Internet and find a recipe for this type of cookie. This recipe will be your “Grandma’s recipe” that you make and sell in your business. Print out this recipe. You must consult your recipe to determine the amount of ingredients required for one dozen cookies. You also must consult Exhibit 1 for information regarding the costs of ingredients, manufacturing overhead, and operating expenses. If your cookies have ingredients that are not included in Exhibit 1, these ingredients are considered part of overhead. 2. Calculate the following: (a) Total variable costs per dozen cookies. (b) Sales price per dozen cookies using “markup on variable costs.” (c) Contribution margin per dozen cookies. (d) Breakeven point for the quarter (three months) in dollars and in units. 3. Short answer questions: (a) Exhibit 1 presents your expenses in the categories of raw materials, manufacturing overhead, and operating expenses. What factors make each of the categories different? (b) Exhibit 1 indicates which costs are fixed and which costs are variable. For each expense listed, indicate why it would be categorized as fixed or variable. PART 2: Master Budget You now have the information you need to create a budget that will allow you to show the banker your plans for the coming year. This budget also will help you to understand your sales and the collection of those sales. You will be able to determine how much money you need to purchase the ingredients for your cookies and to pay your overhead and operating expenses. You realize, "It all begins with sales. If I can estimate how many dozens of cookies I can sell, then I can calculate how many ingredients to buy and how much my overhead and operating expenses will be. Well, I had better get that sales number as accurate as possible." Once you have completed each of your operating budgets you must put it all together to see if you will have profits and see if you have enough money to do what you want to do. You know that you have some of your own money to contribute to the business and you also know that you need to make some equipment purchases. Now it is time for you to develop your pro forma (projected) income statement, balance sheet, and cash budget. Requirements for Part 2: Exhibit 2 presents information regarding your sales projections, expected collection patterns, purchasing and payment patterns for the first four months of the year. Exhibit 3 contains information regarding your plans for capital contributions, equipment purchases, loans, minimum cash balances, and estimated tax rate. 1. Use the spreadsheet template (posted on Canvas) to prepare the following operating budgets: (a) Sales budget/Cash collections Budget (b) Direct materials purchases budget/Cash disbursements budget (c) Manufacturing overhead budget (d) Operating expenses budget 2. Use the information from Exhibit 3 and information from your operating budgets to prepare the following for the first three months of the year: (a) Pro forma variable income statement (Contribution format income statement) (b) Pro forma absorption income statement (Traditional income statement) (c) Cash budget (d) Pro forma balance sheet 3. Short answer questions: (a) Discuss the importance of beginning the master budget process with an accurate sales budget. (b) What are some important factors that a manager should consider when developing a sales budget? State why each factor is important. (c) Distinguish between operating expenses and disbursements for operating expenses. (d) What is the main difference between the variable and absorption income statements? (e) What are the major benefits of budgeting? Instructions for the written assignment: As a team you must submit via Canvas: 1. A copy of the cookie recipe used in your analysis 2. A typed copy of your team’s responses to the above questions. 3. A copy of the excel file used to generate the responses in part 2 Please note that in order to receive full credit (1) all calculations need to be presented in a clear and logical manner (2) All calculations must be linked for each spreadsheet and across the spreadsheets (3) assumptions should be clearly stated and support provided to justify the assumptions (4) short answers should be well articulated and thorough. The written assignment is due via Canvas on 6/7/21. Late assignments will not be accepted. PEER EVALUATION (50 points) Please download and fill-out the peer evaluation. This is an individual submission and needs to be uploaded to the peer evaluation assignment link. Exhibit 1 Sales price, costs of Ingredients, Manufactuing Overhead, and Operating Expenses Sales Price: Mark-up on total variable costs 130% Cost of Raw Materials: Direct Materials Unit Cost Flour/Sugar (any kind) – per cup $0.15 Eggs – per egg $0.20 Butter, Shortening, Oil – per cup* $1.75 Chips/ Nuts, etc. – per cup $1.60 * 1 stick butter = ½ cup Direct Labor Costs: Information regarding direct labor costs is not maintained because your facility is highly automated. Direct labor is included as part of manufacturing overhead. Manufacturing Overhead: Variable Costs Fixed Costs (per dozen) (per month) Utilities $0.30 Other indirect materials and labor $0.50 Maintenance $500 Depreciation $1,300 Supervision $2,200 Total $0.80 $4,000 Operating Expenses: Variable Costs Fixed Costs (per dozen) (per month) Sales Commission $0.20 Shipping Costs $0.65 Salaries $3,000 Depreciation $300 Other $1,000 Total $0.85 $4,300 Exhibit 2 Sales Projections, Collections, Purchases and Payments Monthly sales projections (in dozens of cookies): Sample Number* January The year you were born 2000 February The first four digits of your phone number 2147 March The last four digits of your phone number 6391 April The year you graduated high school 2017 *Enter the appropriate number in this column You have stopped production of cookies at year end to facilitate the expansion of the business. Therefore, you expect to have no uncollected accounts receivables, unpaid accounts payable, or raw material inventories at January 1, the beginning of your budget period. Collections on Sales: Percentage Cash sales are collected in the month of sale. 60% Credit sales are collected in the month following t 40% Production: The company produces the cookies daily. No work-in-process or finished goods inventories are maintained. Raw Materials: The company plans to maintain an ending inventory of raw materials at the end of each month. The company desires to maintain 15% of raw materials production needs for next month. Payment for Raw Materials Percentage Paid in the month of purchase 30%