A B E F H K L M 1 1 2 2 3 Phoneverse Inc. Quarterly 4 5 6 Revenue 7 Expenses 8 COGS Budget 177,934,432.00 $ Quarter 6 Actual 121,352,669.00 $ Quarter 7 Quarter 8 Variance Budget Forecast Variance Budget Forecast Variance 56,581,763.00 $ 195,727,876.00 $ 172,287,114.59 $ 23,440,761.41 $ 215,300,663.00 $ 173,881,470.23 $ 41,419,192.77 $ $ 35,216,004.00 $ 21,488,235.00 $ 13,727,769.00 $ 35,216,004.00 $ 33,565,469.62 $ 1,650,534.38 $ 35,216,004.00 $ 31,013,098.84 $ 4,202,905.16 Human 9 Resources $ 18,602,094.00 $ 8,947,145.00 $ 9,654,949.00 $ 19,081,946.00 $ 8,078,719.68 $ 11,003,226.32 $ 19,596,319.00 $ 7,398,291.90 $ 12,198,027.10 10 Inventory Cost $ 11,000.00 $ $ 11,000.00 $ 580,000.00 $ (162,177.65) $ 742,177.65 $ 570,000.00 $ (324,355.30) $ 894,355.30 11 Marketing $ 30,000,000.00 $ 15,000,000.00 $ 15,000,000.00 $ 30,000,000.00 $ 8,519,770.76 $ 21,480,229.24 $ 30,000,000.00 $ 8,415,929.53 $ 21,584,070.47 12 R&D $ 1,350,000.00 $ 5,967,615.00 $ (4,617,615.00) $ 1,350,000.00 $ 6,894,877.60 $ (5,544,877.60) $ 1,350,000.00 $ 7,951,213.74 $ (6,601,213.74) 13 Other $ 1,000,000.00 $ 5,000,000.00 $ (4,000,000.00) $ 1,125,000.00 $ 4,680,827.39 $ 1,125,000.00 $ 4,843,887.75 14 Total Expenses $ 86,179,098.00 $ 51,402,995.00 $ 34,776,103.00 $ 87,352,950.00 $ 56,896,660.01 $ 30,456,289.99 $ 87,857,323.00 $ 54,454,178.72 $ 33,403,144.28 15 16 EBIT $ 91,755,334.00 $ 69,949,674.00 $ 108,374,926.0 $ 115,390,454.57 $ 127,443,340.00 $ 119,427,291.52 17 18 a. Does your forecast reflect that you are on target with your budget? 19 20 b. If you aren't on target, what is your plan? Are you going to adjust your short-term decisions to align with your budget/company plan? Or are you going to adjust your company plan (and your budget) to reflect the 21 direction that your forecast indicates? Explain. If you are on target, skip to part c. 22 23 C. If you are on target, what decisions are you making that are keeping you on track with your financial goal (i.e., budget)? Is your team satisfied with your current financial position? Explain. 24 25 26 27 28 29 30 31 32 33 34 35 Authors Forecast and Budget Analysis Revenue Forecast COGS Forecast Human Resources Forecast Inventory Costs Forecast Marketing Forecast R&D Forecast Other costs FOI ... + Ready Accessibility: Investigate AutoSave Off H Template Search (Alt+Q) Cuong Nguyen X File Home Insert Page Layout Formulas Data Review View Help Shape Format Comments Share Cut Calibri (Body) 11 AMA AutoSum 2 Wrap Text Accounting E Accento Comma Comma [0] A o Fill Paste A E + 2 Merge & Center $ - % - Currency (6 Copy Format Painter Clipboard Conditional Format as Formatting Tablew Insert Delete Format Percent Currency [0] Sort & Find & Filter Select Analyze Data Clear Undo Font Alignment Number Styles Cells Editing Analysis TextBox 1 A B C D F G H K L M N 0 P Q R S 1 2 Phoneverse Inc. Quarterly 3 4 5 Budget 177,934,432.00 $ Quarter 6 Actual 121,352,669.00 $ Quarter 7 Variance Budget Forecast Variance Budget 56,581,763.00 $ 195,727,876.00 $ 172,287,114.59 $ 23,440,761.41 $ 215,300,663.00 Quarter 8 Forecast $ 173,881,470.23 Variance $ 41,419,192.77 $ 6 Revenue 7 Expenses 8 COGS $ 35,216,004.00 $ 21,488,235.00 $ 13,727,769.00 $ 35,216,004.00 $ 33,565,469.62 $ 1,650,534.38 $ 35,216,004.00 $ 31,013,098.84 $ 4,202,905.16 Human 9 Resources 10 Inventory Cost 11 Marketing 12 R&D 13 Other 14 Total Expenses 15 16 EBIT $ $ $ $ $ $ 18,602,094.00 $ 11,000.00 $ 30,000,000.00 $ 1,350,000.00 $ 1,000,000.00 $ 86,179,098.00 $ 8,947,145.00 $ $ 15,000,000.00 $ 5,967,615.00 $ 5,000,000.00 $ 51,402,995.00 $ 9,654,949.00 11,000.00 $ 15,000,000.00 (4,617,615.00) $ (4,000,000.00) $ 34,776,103.00 $ 19,081,946.00 $ 580,000.00 $ 30,000,000.00 $ 1,350,000.00 $ 1,125,000.00 $ 87,352,950.00 $ 8,078,719.68 $ (162,177.65) $ 8,519,770.76 $ 6,894,877.60 $ 4,680,827.39 56,896,660.01 $ 11,003, 226.32 $ 742,177.65 $ 21,480,229.24 $ (5,544,877.60) $ $ 30,456,289.99 $ 19,596,319.00 $ 570,000.00 $ 30,000,000.00 $ 1,350,000.00 $ 1,125,000.00 $ 87,857,323.00 $ 7,398,291.90 $ (324,355.30) $ 8,415,929.53 $ 7,951,213.74 $ 4,843,887.75 54,454,178.72 $ 12,198,027.10 894,355.30 21,584,070.47 (6,601,213.74) 33,403,144.28 $ 91,755,334.00 $ 69,949,674.00 $ 108,374,926.00 $ 115,390,454.57 $ 127,443,340.00 $ 119,427,291.52 17 O 18 a. Does your forecast reflect that you are on target with your budget? 19 20 b. If you aren't on target, what is your plan? Are you going to adjust your short-term decisions to align with your budget/company plan? Or are you going to adjust your company plan (and your budget) to reflect the 21 direction that your forecast indicates? Explain. If you are on target, skip to part c. 22 C. If you are on target, what decisions are you making that are keeping you on track with your financial goal (i.e., budget)? Is your team satisfied with your current financial position? Explain. 23 24 25 26 O 27 28 29 30 31 32 33 34 35 Authors Forecast and Budget Analysis Revenue Forecast COGS Forecast Human Resources Forecast Inventory Costs Forecast Marketing Forecast R&D Forecast Other costs Foi ... + Ready Accessibility: Investigate 100%