Answered step by step
Verified Expert Solution
Question
1 Approved Answer
need answer to these with info given 2a-Operating budgets You now have the information you need to create a budget that will allow you to
need answer to these with info given 2a-Operating budgets 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 on 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." Requirements for Part 2a: Exhibit 4 presents information regarding your sales projections, expected collection patterns, purchasing and payment patterns for the first several months of the year. 1. Use a new tab on your revised spreadsheet from part 1 to prepare the following operating budgets for each month and the quarter in total: a. Sales budget/Cash collections Budget b. Production budget c. Direct materials budget d. Direct materials cash disbursements budgyt e. Direct labor cash payments budget, assuming that all labor is paid in the month incurred. f. Manufacturing overhead disbursements budget B. Operating expenses disbursements budget Note: When preparing the budgets, you should make maximum use of cell referencing and formulas in the Excel spreadsheets. You should not have to enter the same data more than one time (for example, you should enter monthly sales projections on the sales budget and then use cell referencing from the sales budget to incorporate this information in all of the other budgets). You should use formulas in Excel to perform all of your mathematical calculations. Part of your grade for this assignment will be based on your ability to use these Excel tools. Part2TotalsalesrevenueTotalcashcollectedUnitstoproduceUnitsofDMNeededTotalcostofDMTotalcashpaidforDMTotalcostofdirectlaborTotalMOHTotalOpExTotalCoGSperunitCashPayments-JanuaryCashPayments-FebruaryCashPayments-MarchNetincome(loss)$$$$$$$$$$$$170,204127,84710,74211,70414,2799,44746,32311,68514,2396.6287,70932,56543,27096,306 1. Use a new tab on your revised spreadsheet from part 1 to prepare the fo and the quarter in total: a. Sales budget/Cash collections Budget b. Production budget c. Direct materials budget d. Direct materials cash disbursements budgyt e. Direct labor cash payments budget, assuming that all labor is p f. Manufacturing overhead disbursements budget g. Operating expenses disbursements budget e: When preparing the budgets, you should make maximum use of cel adsheets. You should not have to enter the same data more than one time s projections on the sales budget and then use cell referencing from the sal 2a-Operating budgets 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 on 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." Requirements for Part 2a: Exhibit 4 presents information regarding your sales projections, expected collection patterns, purchasing and payment patterns for the first several months of the year. 1. Use a new tab on your revised spreadsheet from part 1 to prepare the following operating budgets for each month and the quarter in total: a. Sales budget/Cash collections Budget b. Production budget c. Direct materials budget d. Direct materials cash disbursements budgyt e. Direct labor cash payments budget, assuming that all labor is paid in the month incurred. f. Manufacturing overhead disbursements budget B. Operating expenses disbursements budget Note: When preparing the budgets, you should make maximum use of cell referencing and formulas in the Excel spreadsheets. You should not have to enter the same data more than one time (for example, you should enter monthly sales projections on the sales budget and then use cell referencing from the sales budget to incorporate this information in all of the other budgets). You should use formulas in Excel to perform all of your mathematical calculations. Part of your grade for this assignment will be based on your ability to use these Excel tools. Part2TotalsalesrevenueTotalcashcollectedUnitstoproduceUnitsofDMNeededTotalcostofDMTotalcashpaidforDMTotalcostofdirectlaborTotalMOHTotalOpExTotalCoGSperunitCashPayments-JanuaryCashPayments-FebruaryCashPayments-MarchNetincome(loss)$$$$$$$$$$$$170,204127,84710,74211,70414,2799,44746,32311,68514,2396.6287,70932,56543,27096,306 1. Use a new tab on your revised spreadsheet from part 1 to prepare the fo and the quarter in total: a. Sales budget/Cash collections Budget b. Production budget c. Direct materials budget d. Direct materials cash disbursements budgyt e. Direct labor cash payments budget, assuming that all labor is p f. Manufacturing overhead disbursements budget g. Operating expenses disbursements budget e: When preparing the budgets, you should make maximum use of cel adsheets. You should not have to enter the same data more than one time s projections on the sales budget and then use cell referencing from the sal
need answer to these with info given
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started