Hello. I have a project due soon. There should be enough time to complete it.

Accounting Information for Management Decisions 2nd Group Excel Project You have just been hired by Graphic Design as their new President. The company has multiple product lines including a profitable T shirt design business. As the President, one of your first tasks is to review some budgets that were given to you by the Vice President of the T shirt line. Your understanding of this business is limited but your background in accounting has you very interested in reviewing a critical part of the business. You need to complete the following tasks: You will review and complete the budgets listed below on the 2017 budgets. I would also recommend that you spend some time understanding each budget and the relationship to the other budgets. A Traditional Income Statement for the year only needs to be completed. For the Cost of Goods sold, please use the cost of the T shirts, labor and MOH for the calculation. Please link all areas appropriately. A Cost Volume Analysis (CVP) Income Statement also needs to be completed for just the year. Please link all areas appropriately In addition assume, the company actually sells 8,000 units, finish the actual to budget comparison for both the Sales and Administration and MOH budgets using the actuals for the first quarter found on the spreadsheets attached. Complete the flexible budget for S&A and MOH for the different activity levels given. Fill in the Balance Sheet for the company for as well. After reviewing the revised budgets, flexible budgets for the Sales and Administrative and MOH budgets and budget to actual comparison, please discuss in a word document (memo format) about some of the following issues: The owner asks you to explain flexible budgets and their impact on budgeting. Please explain the concept and the importance of this type of budgets. What caused the budget to actual variances? Use your own experience to make some reasonable assumptions for what caused the variances. Please explain and discuss the implications to the company if these trends continue. Evaluate the budgets for any areas that you might be able to recommend some changes. Identify a minimum of three areas for these recommended changes. For example, review the sales commissions currently paid. What is the % and should it be changed? DO NOT use this example in your paper. How do your changes impact the company? Support your conclusions with any calculations that are necessary. (A revised CVP income statement is always a great tool). Your final submission will include the excel worksheets and a word document(about 2-3 pages) Check numbers CVP income statement net income = 295,180 MOH Flexible budget variance = 1561 unit sales unit selling price Graphic Design Sales Budget For year ended Dec 31, 2017 Q1 Q2 Q3 Q4 Total Year 10,000 11,000 21,000 18,000 60,000 $17 $17 $17 $17 $17 $170,000 $187,000 $357,000 $306,000 $1,020,000 Q1 A/R 1st qtr 2nd qtr 3rd qtr 4th qtr $170,000 $187,000 $357,000 $306,000 $0 $119,000 Collections from customers Q2 Q3 Q4 $51,000 130,900 56,100 249,900 $119,000 $181,900 $306,000 107,100 214,200 $321,300 91800 ` shirts to be silk-screened plus: desired ending inventory total shirts less: beginning inventory total shirts needed cost per shirt total cost of shirt purchase A/P 1st qtr 2nd qtr 3rd qtr 4th qtr Q1 10,000 2,750 12,750 0 12,750 $7 $89,250 Graphic Design Production Budgt For the year ended Dec 31, 2017 Q2 Q3 Q4 Total Year 11,000 21,000 18,000 60,000 5,250 4,500 4,500 4,500 16,250 25,500 22,500 64,500 2,750 5,250 4,500 0 13,500 20,250 18,000 64,500 $7 $7 $7 $7 $94,500 $141,750 $126,000 $451,500 payments Q1 $89,250 35,700 $94,500 $141,750 $126,000 $35,700 Q2 53,550 37,800 Q3 18000 Q4 56,700 56,700 85,050 50,400 $91,350 $113,400 $135,450 75600 units to be produced labor hours per unit total labor hours cost per hour total cost Q1 10,000 0.12 1,200 $10 $12,000 Graphic Design Labor Budget For year ended Dec 31, 2017 Q2 Q3 Q4 Total Year 11,000 21,000 18,000 60,000 0.12 0.12 0.12 0.12 1,320 2,520 2,160 7,200 $10 $10 $10 $10 $13,200 $25,200 $21,600 $72,000 Sales commissions Fixed Costs Advertising Rent Sales Salaries Office Salaries Depreciation Property Taxes and Insurance Total Fixed costs Total S&A Expenses Graphic Design S&A budget For the year ended Dec. 31 2017 Q1 Q2 Q3 Q4 Total Year $17,000 $18,700 $35,700 $30,600 $102,000 1,000 750 2,000 1,800 75 95 5,720 $22,720 1,000 750 2,000 1,800 75 95 5,720 $24,420 1,000 750 2,000 1,800 75 95 5,720 $41,420 1,000 4,000 750 3,000 2,000 8,000 1,800 7,200 75 300 95 380 5,720 22,880 $36,320 $124,880 Q1 Variable Expenses Ink Maintenance Utilities Graphics Design Total variable Fixed Expenses Rent Maintenance Utilities Grapics Design Property taxes and insurance Depreciation Total Fixed Total MOH direct labor hours Graphic Design MOH Budget For year ended Dec 31 2017 Q2 Q3 Q4 Total Year $7,500 330 500 1,000 9,330 $8,250 363 550 1,100 10,263 $15,750 693 1,050 2,100 19,593 $13,500 594 900 1,800 16,794 2,250 4,950 3,000 1,500 600 690 12,990 $22,320 2,250 4,950 3,000 1,500 600 690 12,990 $23,253 2,250 4,950 3,000 1,500 600 690 12,990 $32,583 2,250 9,000 4,950 19,800 3,000 12,000 1,500 6,000 600 2,400 690 2,760 12,990 51,960 $29,784 $107,940 1,200 1,320 2,520 2,160 $45,000 1,980 3,000 6,000 55,980 7,200 $14.99 0.75 0.033 0.05 0.1 Beg cash balance add: collections from customers Total available cash Less: Disbursements Payments for shirt purchases Labor MOH S&A Equipment purchases Total Disbursements Excess(deficiency) Financing Borowings Ending Cash Balance Graphic Design Cash Budget For the year ended Dec. 31 2017 Q1 Q2 Q3 $0 $7,025 $22,467 Q4 $20,429 $119,000 $181,900 $306,000 $321,300 $119,000 $188,925 $328,467 $341,729 35,700 12,000 21,630 22,645 40,000 131,975 (12,975) 91,350 13,200 22,563 24,345 15,000 166,458 22,467 113,400 25,200 31,893 41,345 75,000 286,838 41,629 135,450 21,600 29,094 36,245 40,000 262,389 79,340 20,000 $7,025 $22,467 (21,200) $20,429 $79,340 Graphic Design Sales COGS Gross Profit S&A expenses Income from operations Interest Expense Income before income taxes Income taxes Net Income 0 0 0 0 $0 Per unit calculation for COGS: Shirt cost 7 Direct Labor 1.2 MOH $1.80 $10.00 Graphic Design Balance Sheet At Dec. 31 2017 Cash Accounts Receivable Inventory Equipment Less: Accum Deprec Total Assets $0 Accounts Payable Taxes Payable Total Liabilities Michael Woods Capital Total liabilities and Equity 0 $0 Graphic Design Per unit Sales Variable Costs Contribution Margin Fixed Costs Net Income 0 $0 Do not include interest and income taxes on CVP Graphics Design Manufacturing Overhead Flexible Budget Report For the quarter ended March 31, 2017 Sales units Variable expense: Ink ($0.75) Maintenance ($0.033) Utilities ($.05) Graphic Design ($0.10) Total variable expenses Fixed Expenses: Rent Maintenance Utilities Graphic Design Property taxes and Insurance Depreciation Total fixed expenses Total Expenses Original Budget 10,000 Flexible Budget Actual Actual Costs Over (under) Flexible Budget 8,000 $7,000 215 400 1,000 $8,615 $7,000 $215 $400 $1,000 $8,615 $2,250 4,900 2,000 3,000 560 690 $13,400 $13,400 $22,015 $22,015 $2,250 $4,900 $2,000 $3,000 $560 $690 Graphics Desgin Selling & Administrative Flexible Budget Report For the quarter ending March 31, 2017 Original Budget 10,000 Sales units Flexible Budget Actual Actual Costs Over (under) Flexible Budget 8,000 Variable expenses: Sales commision 19,000 19,000 Advertising Rent Sales salaries office salaires Depreciation Property taxes and insurance Total fixed expenses Total selling & administrative expenses 1,500 750 2,000 1,800 90 80 6,220 25,220 1,500 750 2,000 1,800 90 80 6,220 25,220 Total variable expenses Fixed expense: Graphic Design Manufacturing Overhead Flexible Budget For the quarter ending March 31, 2017 Sales units Variable expenses: Ink ($0.75) Maintenance ($.033) Utilities ($0.05) Graphic Design ($0.10) Total variable expenses Fixed expenses: Rent Maintenance Utilities Graphic Design Property taxes and insurance Depreciation Total fixed expenses Total expenses 6,000 7,000 9,000 12,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Graphics Desgin Selling & Administrative Flexible Budget For the quarter ending March 31, 2017 Sales units 6,000 7,000 9,000 12,000 $0 $0 $0 $0 $0 $0 $0 $0 Variable expenses: Sale Commission Fixed expenses: Advertising Rent Salaries office salaries Depreciation Property taxes and insurance Total fixed expenses Total Selling & Administrative expenses