Did you even read the first picture? It has all the questions on it. Just use the information to fill in the excel sheets.

Manufacturing Overhead or of 532.5 per for each of the be Manufacturing h is based on reborho Budete monthly feed overhead is as follows ACC 2610A-Managerial Accounting Budget Project Rased on the information below, you are to prepare allows butts, financial butts and schedules for a byde manufacturer An MS Excel template has been provided to help you in the preparation Note: When using calculations in the template you should transfer values of rounded whole numbers Le not just adjusting the number of digits to the of the decimal Doing calculations in sheets referencing cells in other sheets instead of transferring rounded whole numbers will cause scheduled to not reconcile Wing Bicycle Company manufactures and res of t he 21.5 inch and 225 inch Sales, General Administrative Sales b Sales General and A $11.20 per le expenses p are non A b do e 1.000 per oth Port of the w The sales team has committed to the wing c o unt sales for the next year Jan Feb Mar Apr May A sep Now Dee 215 1047 616 441 372 317 317 318 3 470 225 Bike 3.0 410 051538300280275 275 275 285 365 Cash Cash is expected to be collected t por Decals for the w t h from 2 months o the gro wo d . The price for the 21.5 inch b is 5455 For the 2.5 inch weit is the desired ending Inventory for each month is 15% of the following month's sales for the 21.5 inch and 12 for the 22.5inch bike. The inventory at any of the bucket year is expected to be units of the 15 inch bike and is of the 2.5 inch . The projected sales for lan of the year following the buttare 35 of the 21.5 inch bile and for the 22.5 inch Dec of the prior to the b e st Asume there are in the curred The big chance for the buttywe b The company has estimated we het amounts as fotos Property Plant 52.125.000 for Common Stock and R . on L or 510,915 Materials The total materials for the 21.5 inch b and 22.5inch bear $16445 and 5186 respective of Materials in wwwback for wommation purposes The production department would like to have an ending w a s inventory of 20 of the next month's production requirements Desired end production inwentory for December is SI5.00 for 21.5 inch bike and $15,00 for 22.5inch bike beginning raw mate rwentory value fowlan of the bude yer are $16,370 for the 21.5 inch bike and STR. 507 for the 22. 5inch be Direct Labor Direct laboris 3.9 hours at $15.Sper hour for the 21.5 inch bike and 4 hours at $15.5 per hour for the 22.5inch bike (Process sheet in workbook for information purposes. AB G D E Direct Time Per Labor Pc (Hrs) Rate (Hr) F Variabel OH Rate (DLHR) 0.5 0.25 0.75 Now was own 1 Sequence WorkArea Description 10 Cut Cut Tubing 20 Deburr Deburr Cut Tubing 30 Close Flaten tube ends 40 Weld Weld Tubing for Frame 50 Assembly Assembly 60 Inspect Inspection 70 Package Package Bike Total Time per Unit 0.75 1.25 0.15 0.25 3.9 $ 15.25 $ 22.25 FT Variabel OH Rate (DLHR) Sequence WorkArea Description 10 Cut Cut Tubing 20 Deburr Deburr Cut Tubing 30 Close Flaten tube ends 40 Weld Weld Tubing for Frame 50 Assembly Assembly 60 Inspect Inspection 70 Package Package Bike Total Time per Unit E Direct Time Per Labor Pc (Hrs) Rate (Hr) 0.65 0.25 0.85 0.85 1.4 0.15 0.25 4.4 $ 15.25 $ 22.25 lan Feb Mar May Jun Jul A Sep Oct Nov Dec 2 3 21.5 Bike 22 5 Bike Total Units Total S 882 1183 1151 828 - 507 2 611 - 0 0 - OOOO - F G H J C Feb D Mar E Apr I Aug K Oct L Nov M Dec N Total Jan May Jun Jul Sep 2 21.5 Bike Budgeted Sales 3 22.5 Bike Budgeted Sales 4 21.5 Bike Desired Ending Inventory 5 22.5 Bike Desired Ending Inventory 6 21.5 Bike Total Inventory Required 7 22.5 Bike Total Inventory Required 8 Less: 21.5 Bike Beginning Inventory 9 Less: 22.5 Bike Beginning Inventory 10 21.5 Bike Units to Produce 11 22.5 Bike Units to Produce O 0000 000 000 0 0 0 0 0 0 0 0 0 0 0 12 B C D E F G Jan Feb Mar Apr May Jun Aug Sep Oct 3 Salaries 5 Depreciation 6 Maintenance 7 Insurance 8 Property Taxes 9 Total Fixed Overhead S S S S Feb Mar Apr 2 Budgeted Sales 3 Variable S A rate 4 Variable MBA Expense 5 F SGRA Expense 6 Total SOSA Expenses 7 less: Non Cash Expenses 8 Cash MBA Expenses F G H J C Feb D Mar E Apr I Aug K Oct L Nov M Dec N Total Jan May Jun Jul Sep 2 21.5 Bike Budgeted Sales 3 22.5 Bike Budgeted Sales 4 21.5 Bike Desired Ending Inventory 5 22.5 Bike Desired Ending Inventory 6 21.5 Bike Total Inventory Required 7 22.5 Bike Total Inventory Required 8 Less: 21.5 Bike Beginning Inventory 9 Less: 22.5 Bike Beginning Inventory 10 21.5 Bike Units to Produce 11 22.5 Bike Units to Produce O 0000 000 000 0 0 0 0 0 0 0 0 0 0 0 12 Feb Mar Apr May Jun Jul Aug Sep Oct Nov Beginning units) Beginning SS) 21.513 Prod 5 225 6 21.5 Mare Per Units Material de for Production A n d investor A Male 1 Malera 14 215 M M 15 Male Mat c h NO & .IX A fr B lan C D Mar E Apr F May G Jun H I Aug J K Oct L Nov M Dec N Total O P Feb Jul Sep 2 21.5 Bike (units) 3 22.5 Bike (units) 4 21.5 Bike Direct Labor/Unit 5 22.5 Bike Direct Labor/Unit 6 Labor Hours Required (21.5) 3 Labor Hours Required (22.5) 3 Total Labor Hours Required Direct Labor Rate 0 Direct Labor Costs S S May Jun Jul Aug Sep Oct Total Total Me Oper DH 10 21.5 22 5 OH per unit Ost per unit 100 2 Nof Prior Month 1 Sales Prior Moth Cash Collected 2 Months A Sale 11 Cash Collected 12 Accounts Receivable 2 Accounts Payable 12/31 3 50 X Month 1 SOX Month 2 5 Feb Purchases 6 Mar Purchases 7 Apr Purchases a May Purchases un Purchases Olul Pwchases 1 Aug Purcha 2 Sep Purchases 3 Oct Purchases Now Purchases 500c Purchases Total Disbursements Total Materials to Purchase 2 Beginning Lalance 3 Add: Cash Collections 4 TotalCachable 5 Less: Cash Disbursements Direct labor 8 Manufacturing Overhead GRA 10 Total Disbursements 11 Ending Ca nce E GH D Wing Bicycle Company Budgeted Profit (Loss) Statement for Year Ended 12/31 3 Sales 4 Cost of Goods Sold 5 Gross Margin 6 S, G&A Expenses 7 Operating Income 8 Taxes @ 30% 9 Net Income E Wing Bicycle Company Budgeted Balance Sheet @ 12/31 3 Assets: 4 Cash 5 Accounts Receivable 6 Raw Materials 7 Finished Goods 8 Land 9 Property, Plant & Equipment (Net) 10 Total Assets 13 Liabilities & Stockholders Equity: 14 Accounts Payable 15 Common Stock 16 Retained Earnings 17 Total Liabilities & Stockholders Equity G F H Budgeted Annual Unit Sales Extended Sales Sales: Price Per Unit 21.5 Bike 22.5 Bike Total Sales 0 $ Budgeted Annual Unit Sales Costs: Per Unit Cost Extended Costs 21.5 Bike 22.5 Bike Total Cost of Goods Sold Materials Direct Labor Overhead Ending Ending Total Per Inventory Inventory Unit Cost Units $ - $ 21.5 Bike 22.5 Bike ... Cash Budget Profit (Loss) Statement Balance Sheet Cost of Goods Sold Budget 1 X D E Wing Bicycle Company Statement of Retained Earnings @ 12/31/20XX Retained Earnings 01/01/20XX Less: Dividends Add: Net Income Retained Earnings 12/31/20XX Paste A. Merge LU Macony LCopy - BIU.B. Format Painter Clipboard SECURITY WARNING Macros have been disabled. Font Alignment Enable Content 118 1 x fc F G H Rear B Sprocket Clus & Freewneel 3.65 1 QtyReqd Item 1 Seat Post 1 Saddle 1 Seat Tube 1 Down Tube 1 Top Tube 2 Grips 1 Gear Shifters 1 Handlebar Stem 2 Headset 1 Head Tube 2 Front Brake 1 Forks 1 Quick Release 1 Front Wheel 1 Bottom Bracket 2 Pedal 2 Cranks 1 Chainings 1 Chain 1 Rear Mechanical 1 Rear Wheel 1 Sprocket Cluster 2 Rear Brake Total Cost UnitOfMe asure Each Each Each Each Each Each Each Each Each Each Each Each Each Each Each Each Each Each Each Each Each Each Each CN- ONO- D E Extended Cost Cost 2.5 2.5 7.85 7.85 4.15 4.15 5.95 5.95 5.75 5.75 1.85 3.7 5.8 5.8 2.1 2.1 6.75 13.5 3.65 4.45 8.9 9.75 9.75 5.15 5.15 18.85 18.85 1.95 1.95 4.85 9.7 3.95 7.9 8.45 8.45 10.05 10.05 7.25 7.25 21.75 21.75 12.75 12.75 4.45 8.9 $ 186.30 Rear Wheel Rear Mech Chai 21.5 Bike BOM 22.5 Bike BOM 21.5 Bike Process 22.5 Bike Process dcopy Format Painter BIU. A E Mer Alignment Clipboard Font SECURITY WARNING Macros have been disabled. Enable Content D F G E Extended Cost 2.5 4.35 tyReqd Item 1 Seat Post 1 Saddle 1 Seat Tube 1 Down Tube 1 Top Tube 2 Grips 1 Gear Shifters 1 Handlebar Stem 2 Headset 1 Head Tube 2 Front Brake 1 Forks 1 Quick Release 1 Front Wheel 1 Bottom Bracket 2 Pedal 2 Cranks 1 Chainings 1 Chain 1 Rear Mechanical 1 Rear Wheel 1 Sprocket Cluster 2 Rear Brake Total Cost UnitOfMeasure Each Each Each Each Each Each Each Each Each Each Each Each Each Each Each Each Each Each Cost 2.5 7.85 3.3 4.55 4.35 1.85 5.8 2.1 4.75 3.65 4.45 9.75 5.15 12.85 1.95 4.85 3.95 8.45 7.05 7.25 19.55 9.75 4.45 3.65 8.9 9.75 5.15 12.85 1.95 9.7 7.9 Each Each Each Each Each 8.45 7.05 7.25 19.55 9.75 8.9 $164.45 21.5 Bike ROM Rilco DOMI21 nili Manufacturing Overhead or of 532.5 per for each of the be Manufacturing h is based on reborho Budete monthly feed overhead is as follows ACC 2610A-Managerial Accounting Budget Project Rased on the information below, you are to prepare allows butts, financial butts and schedules for a byde manufacturer An MS Excel template has been provided to help you in the preparation Note: When using calculations in the template you should transfer values of rounded whole numbers Le not just adjusting the number of digits to the of the decimal Doing calculations in sheets referencing cells in other sheets instead of transferring rounded whole numbers will cause scheduled to not reconcile Wing Bicycle Company manufactures and res of t he 21.5 inch and 225 inch Sales, General Administrative Sales b Sales General and A $11.20 per le expenses p are non A b do e 1.000 per oth Port of the w The sales team has committed to the wing c o unt sales for the next year Jan Feb Mar Apr May A sep Now Dee 215 1047 616 441 372 317 317 318 3 470 225 Bike 3.0 410 051538300280275 275 275 285 365 Cash Cash is expected to be collected t por Decals for the w t h from 2 months o the gro wo d . The price for the 21.5 inch b is 5455 For the 2.5 inch weit is the desired ending Inventory for each month is 15% of the following month's sales for the 21.5 inch and 12 for the 22.5inch bike. The inventory at any of the bucket year is expected to be units of the 15 inch bike and is of the 2.5 inch . The projected sales for lan of the year following the buttare 35 of the 21.5 inch bile and for the 22.5 inch Dec of the prior to the b e st Asume there are in the curred The big chance for the buttywe b The company has estimated we het amounts as fotos Property Plant 52.125.000 for Common Stock and R . on L or 510,915 Materials The total materials for the 21.5 inch b and 22.5inch bear $16445 and 5186 respective of Materials in wwwback for wommation purposes The production department would like to have an ending w a s inventory of 20 of the next month's production requirements Desired end production inwentory for December is SI5.00 for 21.5 inch bike and $15,00 for 22.5inch bike beginning raw mate rwentory value fowlan of the bude yer are $16,370 for the 21.5 inch bike and STR. 507 for the 22. 5inch be Direct Labor Direct laboris 3.9 hours at $15.Sper hour for the 21.5 inch bike and 4 hours at $15.5 per hour for the 22.5inch bike (Process sheet in workbook for information purposes. AB G D E Direct Time Per Labor Pc (Hrs) Rate (Hr) F Variabel OH Rate (DLHR) 0.5 0.25 0.75 Now was own 1 Sequence WorkArea Description 10 Cut Cut Tubing 20 Deburr Deburr Cut Tubing 30 Close Flaten tube ends 40 Weld Weld Tubing for Frame 50 Assembly Assembly 60 Inspect Inspection 70 Package Package Bike Total Time per Unit 0.75 1.25 0.15 0.25 3.9 $ 15.25 $ 22.25 FT Variabel OH Rate (DLHR) Sequence WorkArea Description 10 Cut Cut Tubing 20 Deburr Deburr Cut Tubing 30 Close Flaten tube ends 40 Weld Weld Tubing for Frame 50 Assembly Assembly 60 Inspect Inspection 70 Package Package Bike Total Time per Unit E Direct Time Per Labor Pc (Hrs) Rate (Hr) 0.65 0.25 0.85 0.85 1.4 0.15 0.25 4.4 $ 15.25 $ 22.25 lan Feb Mar May Jun Jul A Sep Oct Nov Dec 2 3 21.5 Bike 22 5 Bike Total Units Total S 882 1183 1151 828 - 507 2 611 - 0 0 - OOOO - F G H J C Feb D Mar E Apr I Aug K Oct L Nov M Dec N Total Jan May Jun Jul Sep 2 21.5 Bike Budgeted Sales 3 22.5 Bike Budgeted Sales 4 21.5 Bike Desired Ending Inventory 5 22.5 Bike Desired Ending Inventory 6 21.5 Bike Total Inventory Required 7 22.5 Bike Total Inventory Required 8 Less: 21.5 Bike Beginning Inventory 9 Less: 22.5 Bike Beginning Inventory 10 21.5 Bike Units to Produce 11 22.5 Bike Units to Produce O 0000 000 000 0 0 0 0 0 0 0 0 0 0 0 12 B C D E F G Jan Feb Mar Apr May Jun Aug Sep Oct 3 Salaries 5 Depreciation 6 Maintenance 7 Insurance 8 Property Taxes 9 Total Fixed Overhead S S S S Feb Mar Apr 2 Budgeted Sales 3 Variable S A rate 4 Variable MBA Expense 5 F SGRA Expense 6 Total SOSA Expenses 7 less: Non Cash Expenses 8 Cash MBA Expenses F G H J C Feb D Mar E Apr I Aug K Oct L Nov M Dec N Total Jan May Jun Jul Sep 2 21.5 Bike Budgeted Sales 3 22.5 Bike Budgeted Sales 4 21.5 Bike Desired Ending Inventory 5 22.5 Bike Desired Ending Inventory 6 21.5 Bike Total Inventory Required 7 22.5 Bike Total Inventory Required 8 Less: 21.5 Bike Beginning Inventory 9 Less: 22.5 Bike Beginning Inventory 10 21.5 Bike Units to Produce 11 22.5 Bike Units to Produce O 0000 000 000 0 0 0 0 0 0 0 0 0 0 0 12 Feb Mar Apr May Jun Jul Aug Sep Oct Nov Beginning units) Beginning SS) 21.513 Prod 5 225 6 21.5 Mare Per Units Material de for Production A n d investor A Male 1 Malera 14 215 M M 15 Male Mat c h NO & .IX A fr B lan C D Mar E Apr F May G Jun H I Aug J K Oct L Nov M Dec N Total O P Feb Jul Sep 2 21.5 Bike (units) 3 22.5 Bike (units) 4 21.5 Bike Direct Labor/Unit 5 22.5 Bike Direct Labor/Unit 6 Labor Hours Required (21.5) 3 Labor Hours Required (22.5) 3 Total Labor Hours Required Direct Labor Rate 0 Direct Labor Costs S S May Jun Jul Aug Sep Oct Total Total Me Oper DH 10 21.5 22 5 OH per unit Ost per unit 100 2 Nof Prior Month 1 Sales Prior Moth Cash Collected 2 Months A Sale 11 Cash Collected 12 Accounts Receivable 2 Accounts Payable 12/31 3 50 X Month 1 SOX Month 2 5 Feb Purchases 6 Mar Purchases 7 Apr Purchases a May Purchases un Purchases Olul Pwchases 1 Aug Purcha 2 Sep Purchases 3 Oct Purchases Now Purchases 500c Purchases Total Disbursements Total Materials to Purchase 2 Beginning Lalance 3 Add: Cash Collections 4 TotalCachable 5 Less: Cash Disbursements Direct labor 8 Manufacturing Overhead GRA 10 Total Disbursements 11 Ending Ca nce E GH D Wing Bicycle Company Budgeted Profit (Loss) Statement for Year Ended 12/31 3 Sales 4 Cost of Goods Sold 5 Gross Margin 6 S, G&A Expenses 7 Operating Income 8 Taxes @ 30% 9 Net Income E Wing Bicycle Company Budgeted Balance Sheet @ 12/31 3 Assets: 4 Cash 5 Accounts Receivable 6 Raw Materials 7 Finished Goods 8 Land 9 Property, Plant & Equipment (Net) 10 Total Assets 13 Liabilities & Stockholders Equity: 14 Accounts Payable 15 Common Stock 16 Retained Earnings 17 Total Liabilities & Stockholders Equity G F H Budgeted Annual Unit Sales Extended Sales Sales: Price Per Unit 21.5 Bike 22.5 Bike Total Sales 0 $ Budgeted Annual Unit Sales Costs: Per Unit Cost Extended Costs 21.5 Bike 22.5 Bike Total Cost of Goods Sold Materials Direct Labor Overhead Ending Ending Total Per Inventory Inventory Unit Cost Units $ - $ 21.5 Bike 22.5 Bike ... Cash Budget Profit (Loss) Statement Balance Sheet Cost of Goods Sold Budget 1 X D E Wing Bicycle Company Statement of Retained Earnings @ 12/31/20XX Retained Earnings 01/01/20XX Less: Dividends Add: Net Income Retained Earnings 12/31/20XX Paste A. Merge LU Macony LCopy - BIU.B. Format Painter Clipboard SECURITY WARNING Macros have been disabled. Font Alignment Enable Content 118 1 x fc F G H Rear B Sprocket Clus & Freewneel 3.65 1 QtyReqd Item 1 Seat Post 1 Saddle 1 Seat Tube 1 Down Tube 1 Top Tube 2 Grips 1 Gear Shifters 1 Handlebar Stem 2 Headset 1 Head Tube 2 Front Brake 1 Forks 1 Quick Release 1 Front Wheel 1 Bottom Bracket 2 Pedal 2 Cranks 1 Chainings 1 Chain 1 Rear Mechanical 1 Rear Wheel 1 Sprocket Cluster 2 Rear Brake Total Cost UnitOfMe asure Each Each Each Each Each Each Each Each Each Each Each Each Each Each Each Each Each Each Each Each Each Each Each CN- ONO- D E Extended Cost Cost 2.5 2.5 7.85 7.85 4.15 4.15 5.95 5.95 5.75 5.75 1.85 3.7 5.8 5.8 2.1 2.1 6.75 13.5 3.65 4.45 8.9 9.75 9.75 5.15 5.15 18.85 18.85 1.95 1.95 4.85 9.7 3.95 7.9 8.45 8.45 10.05 10.05 7.25 7.25 21.75 21.75 12.75 12.75 4.45 8.9 $ 186.30 Rear Wheel Rear Mech Chai 21.5 Bike BOM 22.5 Bike BOM 21.5 Bike Process 22.5 Bike Process dcopy Format Painter BIU. A E Mer Alignment Clipboard Font SECURITY WARNING Macros have been disabled. Enable Content D F G E Extended Cost 2.5 4.35 tyReqd Item 1 Seat Post 1 Saddle 1 Seat Tube 1 Down Tube 1 Top Tube 2 Grips 1 Gear Shifters 1 Handlebar Stem 2 Headset 1 Head Tube 2 Front Brake 1 Forks 1 Quick Release 1 Front Wheel 1 Bottom Bracket 2 Pedal 2 Cranks 1 Chainings 1 Chain 1 Rear Mechanical 1 Rear Wheel 1 Sprocket Cluster 2 Rear Brake Total Cost UnitOfMeasure Each Each Each Each Each Each Each Each Each Each Each Each Each Each Each Each Each Each Cost 2.5 7.85 3.3 4.55 4.35 1.85 5.8 2.1 4.75 3.65 4.45 9.75 5.15 12.85 1.95 4.85 3.95 8.45 7.05 7.25 19.55 9.75 4.45 3.65 8.9 9.75 5.15 12.85 1.95 9.7 7.9 Each Each Each Each Each 8.45 7.05 7.25 19.55 9.75 8.9 $164.45 21.5 Bike ROM Rilco DOMI21 nili