Auto Save (O Off) Accounting project v Search (Alt+0) Gaurav Khimani X File Home Insert Drawy Page Layout Formulas Data Review View Help Comments I Share LO Calibri v 11 AA ab Wrap Text General Ex AYO Paste Cell Insert Delete Format Sort & Find & Analyze BIU ~ E Merge & Center $ ~ % " Conditional Format as Formatting ~ Table ~ Styles Filter * Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis L20 X V A B C D E F G H K L M N O P For three years, years ending on Decemeber 31 of 2022, 2023 and 2024 + w 2022 2023 2024 Stock of Finished Goods on January 1 0 151,375 54,135 6 Direct Materials Raw material inventory, January 1 0 163,275 176,847 Raw materials purchases 783,900 1, 646,322 1, 782, 618 ND CO Total raw material avaliable for use 783,900 1,809,597 1,959, 465 10 Less: Raw materials inventory, December 31 -163,275 176,847 -190,995 11 Direct materials use 620, 625 1, 632, 750 1, 768, 470 12 Direct Labor 1, 406, 750 3, 700,900 4,008,532 13 Manufacturing overhead 14 Indirect Material 14, 068 37,009 40, 085 15 Indirect labor 70, 338 185,045 200, 427 16 Factory repairs 1,000 1000 1,000 17 Factory utilities 70, 338 185, 045 200, 427 18 Supervisor Salary 10,000 10,000 10,000 19 Factory depreciation 4,100 4,100 4100 20 Factory insurance and taxes 6,000 5,000 6000 21 Total manufacturing overhead 175, 844 428,199 462,039 22 Total manufacturing costs 2, 203, 219 6, 713,224 7,193,176 23 Total cost of Goods produced 24 Less: Stock of Finished Goods, December 31 -951, 375 -954,135 -1, 030,957 Sales forecast Cost of Goods Manufacturing Sch Income Statements Marketing Budget F ... + + Ready 8% Accessibility: Investigate + 100% :25 PM O 2022-07-15Accounting project v Search (Alt+0) X Auto Save (O Off) Gaurav Khimani File Home Insert Drawy Page Layout Formulas Data Review View Help Comments I Share LO Calibri v 11 AA ab Wrap Text General Ex AYO Paste $ ~ % " Conditional Format as Cell Insert Delete Format Sort & Find & Analyze BIU = Merge & Center Formatting * Table Styles Filter * Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis F19 X V A B C D E F G H J K L M N O SunRype 2022 January February March April May June July August September October November December Total 3 Expected unit sales 105,000 115,000 135,000 150, 000 505,000 Unit price $5 $5 5 Total Sales Revenue $ 525,000 $ 575,000 $ 675,000 $ 750,000 $ 2,525,000 8 2023 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total 9 Expected unit sales 550,000 510,000 520,000 570,000 2,150,0 10 Unit price $5 $5 $5 11 Total Sales Revenue 2, 750,000 $ 2,550,000 $2,600,000 $ 2,850,000 $ 10, 750,000 12 13 14 2024 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total 15 Expected unit sales 585,000 570,000 575,000 600,000 2,330, 000 16 Unit price $5 $5 $5 $5 17 Total Sales Revenue S 2,925,000 $ 2,850,000 $2,875,000 $ 3,000,000 $ 11, 650,000 18 19 20 21 . .. Sales forecast Cost of Goods Manufacturing Sch Income Statements Marketing Budget F ... + 0 + 100% Ready Accessibility: Investigate :25 PM M 2022-07-15Auto Save (O Off) Accounting project v Search (Alt+0) Gaurav Khimani X File Home Insert Drawy Page Layout Formulas Data Reviewy View Help Comments I Share LO Calibri v 11 AA ab Wrap Text General Ex AYO Paste BIU ~ Merge & Center $ ~ % " Conditional Format as Cell Insert Delete Format Sort & Find & Analyze Formatting * Table ~ Styles Filter * Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis F19 X V A B C D E F G H J K L M N O P Name of Company : SunRype 2 Date: June 2022 3 Name of Statement : Martketing budget Marketing Budget for three years 7 Years 2022 2023 2024 8 Marketing Budget: $252,500 $1,075,000 $1,165,000) 9 1. Advertising Expenses: 10 Creative agency fees - Thinkerbell 16,000 48,000 48, 000 11 Newspapers and magazines 40, 000 120,000 120,000 12 Billboards and posters 24,000 96,000 120,000 13 Social Media marketing campaigns 14, 000 60,000 60,000 14 TV ads 0 120,000 144,000 15 Exclusive SunRype vending machines in malls 121,800 451,334 440,184 16 In-store marketing 16,700 116,666 166, 666 17 2. Employee Expenses 18 Marketing Manager for Australia 20, 000 63,000 56,150 19 252,500 1,075,000 1,165,000 20 21 22 1. Marketing budget: The industry practise is to assume 3 to 10 percent of the anticipated sales Sales forecast Cost of Goods Manufacturing Sch Income Statements Marketing Budget F ... + 0 Ready 7% Accessibility: Investigate + + 100% :25 PM 2022-07-15Auto Save (O Off) Accounting project v Search (Alt+0) Gaurav Khimani X File Home Insert Drawy Page Layout Formulas Data Review View Help Comments I Share X Calibri 12 ~ AA ab Wrap Text General Ex AYO Paste BIU- = Merge & Center $ ~ % " Conditional Format as Cell Insert Delete Format Sort & Find & Analyze Formatting * Table ~ Styles Filter * Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis H11 X V fic B C D E F G H K L M Name of Company : SunRype Income Statement Date: June 2022 W N Name of Statement : Martketing budget 2022 2023 2024 Sales Revenue S 2,525,000 $ 10,750,000 $ 11,650,000 6 Finished goods 951,375 954, 135 7 Cost of goods manufactured 1,241, 844 5,759,089 6,162,219 8 Total goods available for sale 1,241,844 6,710,464 7,116,354 9 Finished goods inventory Dec.31 951,375 -954, 135 1,030,957 10 Cost of goods sold 290,469 5,756,329 -6,085,397 11 Gross profit S 2,234,531 $ 4,993,671 $ 5,564,603 12 Operating Expenses 13 Markting Expenses 252,500 1,075,000 1, 165,000 14 Freight Expenses 202,000 860,000 932,000 15 16 Total Operating Expenses -454,500 1,935,000 2,097,000 17 Operating income before tax S 1,780,031 $ 3,058,671 $ 3,467,603 18 less taxes -178,003 -305,867 -346,760 19 Operating income after tax S 1,602,028 $ 2,752,804 $ 3,120,843 20 21 Foot Notes Cost of Goods Manufacturing Sch Income Statements Marketing Budget Freight Budget ( ... + 0 Ready Accessibility: Investigate + + 100% 9 O 1:38 PM 2022-07-15