I need help with my excel project. It is short and i have the template. I just need to input the numbers with cell references. I will be offering max budget.

ACC 2362 Managerial Accounting: Excel Project #2 - Chapters 6 & 7 - Cost Behavior, High-Low Method, Contribution Margin Income Statement, and Break-Even Analysis 1. Read these instructions completely before you begin the Excel project. 2. Academic Honesty: The project should reflect your individual work. This is NOT a group project - sharing answers or spreadsheet formats is considered academic dishonesty. If you use a spreadsheet from a prior semester or someone else's spreadsheet, you will receive a zero for the project and an honor code violation will be filed. 3. Due date: Monday, October 17th at the START of your class period or earlier. If you arrive more than 10 minutes late to class to turn in your project, there will be a 25% penalty. If you turn it in after class has ended, you will NOT receive credit for the assignment. 4. Deliverables: Attach a copy of the cover sheet to a printed copy of the completed Excel spreadsheet which will be turned in during your class period. An electronic copy of the Excel spreadsheet only (no cover sheet) will be submitted to TRACS via the Drop Box function in accordance with the due date and time stated above. You will not receive credit unless both the printed copy and electronic copy are turned in by the due date. No hand written assignments or e-mail attachments will be accepted. 5. Specific Directions: This assignment will not be done through MyAccountingLab. It must be completed using Excel, a spreadsheet application. Use the Excel Project #2 F16 template as your starting point. Remember not to use a spreadsheet from a prior semester or someone else's spreadsheet or you will receive a zero for the project. The data included in the template will serve as your data source for all your other cells in Excel. Everything you add in the template should either be a cell reference or an Excel formula. No hard-coded numbers. Add page numbers within Excel if your assignment is more than one page. Print portrait on only one side of the page (no double-sided). Review the Excel Instructions and Hints posted for the first Excel Project. 6. Grading: Assignment is worth 10 points. Presentation of the information and how easily it can be read will be considered in the grading of the project. 6 points will be for the content, accuracy of the calculations, and completeness. 4 points will be for the use of technology and communication of data. 7. Excel Help: See TRACS - Resources for a sheet offering Microsoft Office keyboard short cuts. CIS tutoring lab McCoy 336 YouTube offers many Excel tutorials. Office hours: TA Jordan Draper: Tuesday, October 11th from 2:00 to 4:00 pm in McCoy 442 Professors regularly scheduled office hours. Come by the office if you need help. 8. Lastly, remember, the project is due at the START of your class period. There is normally a back up in the computer lab on the due date with students printing the assignment at the last hour so don't be caught. Remember, there are penalties associated with late work. Don't wait until the last minute to work on it, print out the results to review it for accuracy. Do your own work! ACC 2362 Managerial Accounting: Excel Project #2 - Chapters 6 & 7 - Cost Behavior, High-Low Method, Contribution Margin Income Statement, and Break-Even Analysis Edwards & Shaw is a merchandising company that is the sole distributor of a product that is increasing in popularity. The company's income statement for the three most recent months is listed below. Edwards and Shaw Income Statement For the Three Months Ending September Sales in Units Sales Revenue Cost of Goods Sold Gross Margin Operating Expenses: Advertising Expense Shipping Expense Salaries and Commissions Legal Expense Depreciation Expense Total Operating Expenses Operating Income July 3,000 August 6,000 September 7,500 $900,000 255,000 645,000 $1,800,000 480,000 1,320,000 $2,250,000 592,500 1,657,500 8,500 16,500 72,000 5,000 12,000 114,000 $531,000 8,500 33,000 99,000 5,000 12,000 157,500 $1,162,500 8,500 41,250 112,500 5,000 12,000 179,250 $1,478,250 1. Identify each of the company's individual expenses (both product and period) as either a variable, fixed or mixed cost. 2. Using the high-low method, separate each of the individual mixed cost into the variable rate and fixed cost elements. State the cost equation for each individual mixed costs. 3. Edwards and Shaw expect to sell 8,000 units in October. Prepare an absorption income statement for October. 4. Prepare a Contribution Margin Income Statement based on October sales of 8,000 units. Do not combine expenses but show each expense separately in the appropriate category. 5. Calculate the contribution margin per unit and the variable cost ratio. 6. How many units would need to be sold to generate $2,000,000 in target income? (Round your answer to the nearest unit using the Excel Round Up function.) 7. Give one example of how Edwards and Shaw could increase projected operating income without increasing total sales revenue. 8. Edwards and Shaw are considering a multimedia advertising campaign that should increase sales by $50,000 per month. The ad campaign will cost an additional $1,500 per month and will be considered a fixed cost. How will the ad campaign affect product cost? How will the increase in fixed costs affect the break-even point? Explain. Income Statement For the Three Months Ending September 30th July Sales in Units Sales Revenue $ Cost of Goods Sold Gross Margin Operating Expenses: Advertising expense Shipping expense Salaries and commiss Legal expense Depreciation expense Total Operating Expen Operating Income $ August September 3,000 6,000 7,500 900,000 $ 255,000 645,000 1,800,000 $ 480,000 1,320,000 2,250,000 592,500 1,657,500 8,500 16,500 72,000 5,000 12,000 114,000 531,000 $ 8,500 33,000 99,000 5,000 12,000 157,500 1,162,500 $ ### 41,250 112,500 ### ### 179,250 1,478,250 1) Identify each of the company's expenses as either variable, fixed, or mixed. For the FC list the total fixed costs per month for each month. For VC list the variable cost per unit for each month. For MC list the total average cost per unit for each mixed cost per month. July August September Fixed Costs Variable Costs Mixed Costs 2) Using the high-low method, separate each of the mixed expenses into variable and fixed elements. State the cost equation for each mixed cost. You may have more than one mixed cost. Variable Rate Fixed Cost Cost Formula It's Ok to type the cost formula directly into the cells, although you will not receive credit if the variable rate and fixed costs are not calculated using Excel cell references and formulas. 3. Edwards and Shaw expect to sell 8,000 units in October. Prepare an absorption income statement for October (assume we produce and sell the same number of units). Sales in Units Sales Revenue 8,000 Operating Income 4) Prepare a Contribution Margin Income Statement based on the October sales of 8,000 units (assume we produce and sell the same number of units.) Do not combine expenses but show each expense separately in the appropriate category. Sales in Units 8,000 Sales Revenue Operating Income 5) Calculate the contribution margin per unit. Calculate the variable cost ratio. 6) Calculate how many units would need to be sold to generate $2,000,000 in target income. Round up to the nearest unit using the Excel Round Up function. Target Incom $ 2,000,000 7) Give one example of how Edwards and Shaw could increase projected operating income without increasing total sale revenue. 8) Edwards and Shaw are considering a multimedia advertising campaign that should increase sales by $50,000 per month. The ad campaign will cost an additional $1,500 per month and will be considered a fixed cost. How will the ad campaign affect product cost? How will the increase in fixed costs affect the break-even point? Explain. 8) Edwards and Shaw are considering a multimedia advertising campaign that should increase sales by $50,000 per month. The ad campaign will cost an additional $1,500 per month and will be considered a fixed cost. How will the ad campaign affect product cost? How will the increase in fixed costs affect the break-even point? Explain. receive references me without d increase th and will be increase in d increase th and will be increase in