Hello can i get help with these problem? Thank you.
Hopefully these arnt as blurry. i need help with the formuls and the questions. Thank you.
Instructions Formulas Roq 1 Che Reg 2 Ch8 B D E F 2 1 73.00 ON Copy Formulas Data Yw2Q 1 40.000 60.000 100.000 0.000 Selling price per per - Accountable beginning balance 000 9 Balaclected in the are made 10 Selected in the generales de 25 11 Desired ending the good wory 90% of the budgeted at 12 Finished poodie inventory beginning 12.000 13 - producent 14 -Desired and now af www Son of the producto 15 Raw material wory beginning 23.000 pounde 16 Remote 500 per perd 17 Rare purchaserred 80% e quarter the purchase 18 and 40% in the catering purchase 19 Afromater, beginning balance 561500 020 21 Enter a formule into each of the green calls marked with 7 helow. Once completo use the Copy Formal Sutton 22 Review Problem Schedules 23 24 Canare the sales budget You 25 2 26 Budged units 27 Selling prica per 28 Total 29 30 Contract the schedule a expected cash collection Yar 2 O 31 3 32 Accountable beginning wance 33 34 Decoder 35 Third 36 Fourth-ories 37 Total cash collection 38 39 Control the production budget Yower 40 2 41 Budged 42 Add desired finished goods 7 43 Tastra 44 7 ? 45 7 Hequired production 46 47 Construct the raw materiale purchases budget Yer Quarter 48 2 3 49 Reproduction du 50 Raw materials are le producent 51 Production needs sounds 52 7 7 Auf der ending inventory of raw pounds) 53 Y 7 7 Total pound 54 7 Les being matery of raw mapunde 55 Ruw me to be purchased 7 7 56 Cost of water per pound 57 Coal of raw materials to be purchased 58 59 Construct the schedule of weed cash payment Year 2 Quarter 3 60 61 Accounts pel begining balance 62 First quarter purchase Second quarter purchases 64 Third quarto purchase 65 Foursquarter purchase Total cash disbursements 67 63 66 U L M N O Enter $75,000 for the budgeted unit sales in Quarter 2 of Year 2 in the green cell on the left. If the total expected cash collections are $2,085,000 your formulas are correct. If not, correct your formulas on the previous page and recopy the formulas using the copy formulas button. Have the total cash disbursements for the year changed? Why or why not? 2 Magnussen we het dit change the + TO www www www 12000 Or 11 dal wat te vind ek w nowe 3 1 What are the theatres reyer was the > . her HA H. A Le + Req. 2. The company has hired a new marketing manager who would like to make changes in budgeted unit sales and the selling price. Enter the data changes given for requirement 2 in the textbook in the green data cells on the left. What are the new total expected cash collections for the year under this revised budget? What is the total required production for the year under this revised budget? What is the total cost of raw materials to be purchased for the year under this revised budget? What are the total expected cash disbursements for raw materials for the year under this revised budget? After seeing the revised budget, the production manager cautioned that the plant can produce no more than 90,000 units in a quarter. Is this a potential problem? 7 If so, what can be done about it? Instructions Formulas Reg 1 Ch8 Rog 2 Cha B H 1 Chapter: Applying Excel Name: G# Data T 40,000 Yow 2 Quarter 2 3 60.000 100,000 4 50.000 Year 3 Quarter 1 2 70,000 80,000 Soling price per unit 10 per unit Accounts receivable beginning balance 565.000 9 Seles collected in the areas we made 754 10 Salas colected in the quarter afar sales are made 25% 11 De redonding finished goods inventory is 30% of the budgeted untes of the best quarter 12 Finished goods viventory beginning 12,000 unis 13 Raw material required to producent 5 pounds 14 Detired andre very of raw materiais 10% of the best quarter's production neede 15 Raw materials vertory beginning 23,000 pounds 15 -Raw materweg 500 per pound 12 Raw material purchase pod con in the quarter the purchases are made 10 w 40% in the quanto fotowing purchase 10 Moura payable for raw materials, beginning balance 381 500 20 21 Enter a formula Into each of the green calle marked with 2 below. Once complete use the Copy Formula buffon Review Problem Budget Schedules Copy Formulas + 40.000 LA $320.000 Voor Ouarter 2 3 10.000 100.000 EN 110.000 120.000 Year Outer 1 2 10.000 SA 3.500.000 1040001 30,000 15 5400.000 70.000 Your 2 w 4 Ver 5 65.000 24 Construct the sales budget 26 26 27 ng price per un 20 To 20 30 Construer the schedule of expected cash collections 31 32 Accounts receivable beginning sa in quanto 34 second quarter sales 35 Third quarters 35 Fourth quale Totalcan collection se Construct the production budget 40 41 Runners 42 Add defe goods inventory Total needs Los beginning watory Required reduction 7 2 7 Yaar 2 O 3 Yaar 7 2 Ya Querfor 2 2 4 7 7 2 2 2 2 7 Construct the raw materials purchases budget Year 2 48 Year Quer 3 Instructions Formulas Reg 1 Che Reg 2 CHE A D E G H Yon 3 Quartar 2 Copy Formulas 1 70.000 50,000 3560.000 5640.000 Year 21 Enter la formula into each of the green calls marked with a 7 below. Once complete use the "Copy Formula" button 22 Review Problem Budget Schedule 23 24 Construct the sales budget Your 2 Quarto 25 1 2 3 20 Budgeed unit sales 40.000 60.000 100.000 50,000 Selling price per 58 $8 58 28 Total sales $320.000 $180.000 $500 000 5400.000 29 30 Construct the schedule of expected cash collections Year 2 Quar 81 1 3 4 32 Accounts receivable begiving balance 5 68.000 33 Fint quarters 34 Second quarters 35 Third- gales 36 Fourth quarter sales 37 Tocal cash collections 38 30 Construct the production budget Year 2 Quar 40 3 41 Botold unit sales 7 Add desired finished goods Inventory 7 2 Total needs ? 2 44 Los teginning inventory 7 2 2 45 Required production 9 7 2 2 Year Your 3 Our 2 7 Yer 2 www.tr 2 2 Year 3 1 Your 2 ? 2 2 7 ? 2 2 2 2 ? 7 2 2 ? 2 2 2 2 2 7 2 ? 2 2 2 47 Construct the raw materials purchases budget 18 40 Required production units) 50 Raw material required to produce one unit 51 Production round) 52 Add desired ending inventory framewounds 58 Total needs (pounds) 50 Loss beginning wenty of raw material pounds) 50 Raw materials to be purchased 50 Cost of raw materials per pound 57 Cout of raw materials to be purchased BB 59 Construct the schedule of expected cash payments 60 61 Apayati, beginning balance 32 Fique purchase Second-quarter purchases Third-quarter purchase 05 Fourth quarter purchases 00 Totalcashme 07 7 2 2 1 2 7 Year 2 Owner 4 Ya Instructions Formulas Reg 1 Ch8 Reg 2 Ch8 A B C D E F Chapter 8: Applying Excel Data 0.00 - 0 2 Your 2 Our 3 100.000 Year Quarter 1 2 70,000 Budgeted 40,000 50,000 o per un 365.000 75% 20% 30% of the budgeted units of the starter 12,000 units 5 pounds 10% of the quarters production needs 23.000 pounds 30 80 per pound 80% ne quarter the purchases are made 40% the quarto following purchase 501.500 Year Quarter 1 ? 7 7 Yar 2 Quarter 3 7 7 7 2 ? 7 2 2 ? 7 2 ? 7 Ya 2 Ouarter 3 + 2 4 ? Selling price per 8 - Accounts recette in balance Saecolected in the quarter sales are made 10 Sales collected in the quarter were made 11 Desired dig ned goose 12 - Finished goods inventory beginning 13 Femals required to producent 14 Desired ending inventory of 15 Rowery beginning 16 17 18 Accounts payable for raw materials, Beginning balance 20 21 22 Review Problem Budget Schedules 23 24 Constrw the sales budget 25 26 Budgeted units 27 Sing priceperunt 28 29 30 Cenate the schedule of expected cash collection 31 32 Accueva, beginning balance 33 First quarter les Secondaria 35 Third-quarters 36 Fourrurerie 37 Teleshoone 38 39 Constructhe production budget 40 Busted unit 42 Add to had good wory 43 Toode Lastering in Reduction 45 47 Constthew materiale purchases 48 49 50 151 Praction pound ) 52 Molded and more pounds) 53 54 55 hed 56 Cost of 57 58 59 60 61 62 2 7 7 2 7 7 2 2 ? 7 2 Year 2 Quarter Yo Quarter 1 2 3 7 ? 9 2 7 7 ? ? 2 7 7 7 ? 2 7 7 2 2 2 7 Yer 2 Outer 2 Ya Quarto 2 2 7 7 7 2 2 7 7 ? 7 7 2 7 1 7 1 7 7 ? 7 7 2 7 7 2 2 2 7 2 7 2 > + 2 water 2 The purchas Fourth purchase 64 65 66 67 2 7 VIO Req1 Ch8 Reg 2 Ch8 K M N O 1: Enter $75,000 for the budgeted unit sales in Quarter 2 of Year 2 in the green cell on the left. If the total expected cash collections are $2,085,000 your formulas are correct. If not, correct your formulas on the previous page and recopy the formulas using the copy formulas button. Have the total cash disbursements for the year changed? Why or why not? Instructions Formulas Req 1 Cha Reg 2 Cha A D F Chapter 8: Applying Excel Data 3 4 5 Yoar 2 Quarter Year 3 Quarter 2 3 Budgeted unit sales 2 7. 9 10 11 12 13 14 15 10 17 18 19 20 21 22 Seiling price per unit - Accounts receivable, beginning balance - Sales collected in the quarter sales are made Sales collected in the quarter after sales are made Desired ending finished goods inventory is - Finished goods inventory beginning Raw materials required to produce one unit .Desired ending Inventory of raw materials is Raw materials inventory beginning Raw material costs Raw materials purchases are paid and - Accounts payable for raw materials, beginning balance per unit $65000 75% 25% 30% of the budgeted unit sales of the next quarter 12.000 units 5 pounds 10% of the next quarter's production needs 23.000 pounds $0.80 per pound 60% in the quarter the purchases are made 40% in the quarter following purchase $31.500 Review Probleme Budget Schedules 1 2 4 1 ? 2 2 Year 2 Quarter 3 2 ? 7 ? 2 2 ? 2 7 Year 3 Quarter 2 2 ? ? 2 ? 2 Year 2 Quito 2 3 4 Year 7 2 ? 2 7 2 7 7 ? 2 7 ? 7 2 2 24 Construct the sales budget 25 26 Budgeted unit sales 27 Selling price per unit 28 Total sales 29 30 Construct the schedule of expected cash collections 31 32 Accounts receivable beginning balance 33 First Quarter Sales 34 Second quarter sales 35 Third quarter sales 36 Fourth quarter sales 37 Total cash collections 38 39 Construct the production budget 40 41 Budgeted unit sales 42 Add desired finished goods inventory 43 Tot needs 44 Less beginning inventory 45 Required production 45 47 Construct the raw materials purchases budget 4B 49 Required production (units) 50 Raw materials required to produce one unit 51 Production noods (pounds) 52 Add desired ending inventory of raw materials Counde) Vear Quarter T 2 Year ? ? 2 2 2 Year 2 Quarter 3 ? 2 2 7 7 ? ? 7 7 2 2 2 7 2 2 2 ? ? 2 2 2 7 2 2 2 4 Year 2 7 7 7 2 Year 2 Quarter 3 ? 2 2 2 Year 3 Quarter 1 7 2 2 2 ? ulas Reg 1 Ch8 Req 2 Ch8 G 1 J K M N O P Reg. 2: The company has hired a new marketing manager who would like to make changes in budgeted unit sales and the selling price. Enter the data changes glven for requirement 2 in the textbook in the green data cells on the left. What are the new total expected cash collections for the year under this revised budget? What is the total required production for the year under this revised budget? What is the total cost of raw materials to be purchased for the year under this revised budget? What are the total expected cash disbursements for raw materials for the year under this revised budget? After seeing the revised budget, the production manager cautioned that the plant can produce no more than 90,000 units in a quarter. Is this a potential problem? ? If so, what can be done about it? Instructions Formulas Roq 1 Che Reg 2 Ch8 B D E F 2 1 73.00 ON Copy Formulas Data Yw2Q 1 40.000 60.000 100.000 0.000 Selling price per per - Accountable beginning balance 000 9 Balaclected in the are made 10 Selected in the generales de 25 11 Desired ending the good wory 90% of the budgeted at 12 Finished poodie inventory beginning 12.000 13 - producent 14 -Desired and now af www Son of the producto 15 Raw material wory beginning 23.000 pounde 16 Remote 500 per perd 17 Rare purchaserred 80% e quarter the purchase 18 and 40% in the catering purchase 19 Afromater, beginning balance 561500 020 21 Enter a formule into each of the green calls marked with 7 helow. Once completo use the Copy Formal Sutton 22 Review Problem Schedules 23 24 Canare the sales budget You 25 2 26 Budged units 27 Selling prica per 28 Total 29 30 Contract the schedule a expected cash collection Yar 2 O 31 3 32 Accountable beginning wance 33 34 Decoder 35 Third 36 Fourth-ories 37 Total cash collection 38 39 Control the production budget Yower 40 2 41 Budged 42 Add desired finished goods 7 43 Tastra 44 7 ? 45 7 Hequired production 46 47 Construct the raw materiale purchases budget Yer Quarter 48 2 3 49 Reproduction du 50 Raw materials are le producent 51 Production needs sounds 52 7 7 Auf der ending inventory of raw pounds) 53 Y 7 7 Total pound 54 7 Les being matery of raw mapunde 55 Ruw me to be purchased 7 7 56 Cost of water per pound 57 Coal of raw materials to be purchased 58 59 Construct the schedule of weed cash payment Year 2 Quarter 3 60 61 Accounts pel begining balance 62 First quarter purchase Second quarter purchases 64 Third quarto purchase 65 Foursquarter purchase Total cash disbursements 67 63 66 U L M N O Enter $75,000 for the budgeted unit sales in Quarter 2 of Year 2 in the green cell on the left. If the total expected cash collections are $2,085,000 your formulas are correct. If not, correct your formulas on the previous page and recopy the formulas using the copy formulas button. Have the total cash disbursements for the year changed? Why or why not? 2 Magnussen we het dit change the + TO www www www 12000 Or 11 dal wat te vind ek w nowe 3 1 What are the theatres reyer was the > . her HA H. A Le + Req. 2. The company has hired a new marketing manager who would like to make changes in budgeted unit sales and the selling price. Enter the data changes given for requirement 2 in the textbook in the green data cells on the left. What are the new total expected cash collections for the year under this revised budget? What is the total required production for the year under this revised budget? What is the total cost of raw materials to be purchased for the year under this revised budget? What are the total expected cash disbursements for raw materials for the year under this revised budget? After seeing the revised budget, the production manager cautioned that the plant can produce no more than 90,000 units in a quarter. Is this a potential problem? 7 If so, what can be done about it? Instructions Formulas Reg 1 Ch8 Rog 2 Cha B H 1 Chapter: Applying Excel Name: G# Data T 40,000 Yow 2 Quarter 2 3 60.000 100,000 4 50.000 Year 3 Quarter 1 2 70,000 80,000 Soling price per unit 10 per unit Accounts receivable beginning balance 565.000 9 Seles collected in the areas we made 754 10 Salas colected in the quarter afar sales are made 25% 11 De redonding finished goods inventory is 30% of the budgeted untes of the best quarter 12 Finished goods viventory beginning 12,000 unis 13 Raw material required to producent 5 pounds 14 Detired andre very of raw materiais 10% of the best quarter's production neede 15 Raw materials vertory beginning 23,000 pounds 15 -Raw materweg 500 per pound 12 Raw material purchase pod con in the quarter the purchases are made 10 w 40% in the quanto fotowing purchase 10 Moura payable for raw materials, beginning balance 381 500 20 21 Enter a formula Into each of the green calle marked with 2 below. Once complete use the Copy Formula buffon Review Problem Budget Schedules Copy Formulas + 40.000 LA $320.000 Voor Ouarter 2 3 10.000 100.000 EN 110.000 120.000 Year Outer 1 2 10.000 SA 3.500.000 1040001 30,000 15 5400.000 70.000 Your 2 w 4 Ver 5 65.000 24 Construct the sales budget 26 26 27 ng price per un 20 To 20 30 Construer the schedule of expected cash collections 31 32 Accounts receivable beginning sa in quanto 34 second quarter sales 35 Third quarters 35 Fourth quale Totalcan collection se Construct the production budget 40 41 Runners 42 Add defe goods inventory Total needs Los beginning watory Required reduction 7 2 7 Yaar 2 O 3 Yaar 7 2 Ya Querfor 2 2 4 7 7 2 2 2 2 7 Construct the raw materials purchases budget Year 2 48 Year Quer 3 Instructions Formulas Reg 1 Che Reg 2 CHE A D E G H Yon 3 Quartar 2 Copy Formulas 1 70.000 50,000 3560.000 5640.000 Year 21 Enter la formula into each of the green calls marked with a 7 below. Once complete use the "Copy Formula" button 22 Review Problem Budget Schedule 23 24 Construct the sales budget Your 2 Quarto 25 1 2 3 20 Budgeed unit sales 40.000 60.000 100.000 50,000 Selling price per 58 $8 58 28 Total sales $320.000 $180.000 $500 000 5400.000 29 30 Construct the schedule of expected cash collections Year 2 Quar 81 1 3 4 32 Accounts receivable begiving balance 5 68.000 33 Fint quarters 34 Second quarters 35 Third- gales 36 Fourth quarter sales 37 Tocal cash collections 38 30 Construct the production budget Year 2 Quar 40 3 41 Botold unit sales 7 Add desired finished goods Inventory 7 2 Total needs ? 2 44 Los teginning inventory 7 2 2 45 Required production 9 7 2 2 Year Your 3 Our 2 7 Yer 2 www.tr 2 2 Year 3 1 Your 2 ? 2 2 7 ? 2 2 2 2 ? 7 2 2 ? 2 2 2 2 2 7 2 ? 2 2 2 47 Construct the raw materials purchases budget 18 40 Required production units) 50 Raw material required to produce one unit 51 Production round) 52 Add desired ending inventory framewounds 58 Total needs (pounds) 50 Loss beginning wenty of raw material pounds) 50 Raw materials to be purchased 50 Cost of raw materials per pound 57 Cout of raw materials to be purchased BB 59 Construct the schedule of expected cash payments 60 61 Apayati, beginning balance 32 Fique purchase Second-quarter purchases Third-quarter purchase 05 Fourth quarter purchases 00 Totalcashme 07 7 2 2 1 2 7 Year 2 Owner 4 Ya Instructions Formulas Reg 1 Ch8 Reg 2 Ch8 A B C D E F Chapter 8: Applying Excel Data 0.00 - 0 2 Your 2 Our 3 100.000 Year Quarter 1 2 70,000 Budgeted 40,000 50,000 o per un 365.000 75% 20% 30% of the budgeted units of the starter 12,000 units 5 pounds 10% of the quarters production needs 23.000 pounds 30 80 per pound 80% ne quarter the purchases are made 40% the quarto following purchase 501.500 Year Quarter 1 ? 7 7 Yar 2 Quarter 3 7 7 7 2 ? 7 2 2 ? 7 2 ? 7 Ya 2 Ouarter 3 + 2 4 ? Selling price per 8 - Accounts recette in balance Saecolected in the quarter sales are made 10 Sales collected in the quarter were made 11 Desired dig ned goose 12 - Finished goods inventory beginning 13 Femals required to producent 14 Desired ending inventory of 15 Rowery beginning 16 17 18 Accounts payable for raw materials, Beginning balance 20 21 22 Review Problem Budget Schedules 23 24 Constrw the sales budget 25 26 Budgeted units 27 Sing priceperunt 28 29 30 Cenate the schedule of expected cash collection 31 32 Accueva, beginning balance 33 First quarter les Secondaria 35 Third-quarters 36 Fourrurerie 37 Teleshoone 38 39 Constructhe production budget 40 Busted unit 42 Add to had good wory 43 Toode Lastering in Reduction 45 47 Constthew materiale purchases 48 49 50 151 Praction pound ) 52 Molded and more pounds) 53 54 55 hed 56 Cost of 57 58 59 60 61 62 2 7 7 2 7 7 2 2 ? 7 2 Year 2 Quarter Yo Quarter 1 2 3 7 ? 9 2 7 7 ? ? 2 7 7 7 ? 2 7 7 2 2 2 7 Yer 2 Outer 2 Ya Quarto 2 2 7 7 7 2 2 7 7 ? 7 7 2 7 1 7 1 7 7 ? 7 7 2 7 7 2 2 2 7 2 7 2 > + 2 water 2 The purchas Fourth purchase 64 65 66 67 2 7 VIO Req1 Ch8 Reg 2 Ch8 K M N O 1: Enter $75,000 for the budgeted unit sales in Quarter 2 of Year 2 in the green cell on the left. If the total expected cash collections are $2,085,000 your formulas are correct. If not, correct your formulas on the previous page and recopy the formulas using the copy formulas button. Have the total cash disbursements for the year changed? Why or why not? Instructions Formulas Req 1 Cha Reg 2 Cha A D F Chapter 8: Applying Excel Data 3 4 5 Yoar 2 Quarter Year 3 Quarter 2 3 Budgeted unit sales 2 7. 9 10 11 12 13 14 15 10 17 18 19 20 21 22 Seiling price per unit - Accounts receivable, beginning balance - Sales collected in the quarter sales are made Sales collected in the quarter after sales are made Desired ending finished goods inventory is - Finished goods inventory beginning Raw materials required to produce one unit .Desired ending Inventory of raw materials is Raw materials inventory beginning Raw material costs Raw materials purchases are paid and - Accounts payable for raw materials, beginning balance per unit $65000 75% 25% 30% of the budgeted unit sales of the next quarter 12.000 units 5 pounds 10% of the next quarter's production needs 23.000 pounds $0.80 per pound 60% in the quarter the purchases are made 40% in the quarter following purchase $31.500 Review Probleme Budget Schedules 1 2 4 1 ? 2 2 Year 2 Quarter 3 2 ? 7 ? 2 2 ? 2 7 Year 3 Quarter 2 2 ? ? 2 ? 2 Year 2 Quito 2 3 4 Year 7 2 ? 2 7 2 7 7 ? 2 7 ? 7 2 2 24 Construct the sales budget 25 26 Budgeted unit sales 27 Selling price per unit 28 Total sales 29 30 Construct the schedule of expected cash collections 31 32 Accounts receivable beginning balance 33 First Quarter Sales 34 Second quarter sales 35 Third quarter sales 36 Fourth quarter sales 37 Total cash collections 38 39 Construct the production budget 40 41 Budgeted unit sales 42 Add desired finished goods inventory 43 Tot needs 44 Less beginning inventory 45 Required production 45 47 Construct the raw materials purchases budget 4B 49 Required production (units) 50 Raw materials required to produce one unit 51 Production noods (pounds) 52 Add desired ending inventory of raw materials Counde) Vear Quarter T 2 Year ? ? 2 2 2 Year 2 Quarter 3 ? 2 2 7 7 ? ? 7 7 2 2 2 7 2 2 2 ? ? 2 2 2 7 2 2 2 4 Year 2 7 7 7 2 Year 2 Quarter 3 ? 2 2 2 Year 3 Quarter 1 7 2 2 2 ? ulas Reg 1 Ch8 Req 2 Ch8 G 1 J K M N O P Reg. 2: The company has hired a new marketing manager who would like to make changes in budgeted unit sales and the selling price. Enter the data changes glven for requirement 2 in the textbook in the green data cells on the left. What are the new total expected cash collections for the year under this revised budget? What is the total required production for the year under this revised budget? What is the total cost of raw materials to be purchased for the year under this revised budget? What are the total expected cash disbursements for raw materials for the year under this revised budget? After seeing the revised budget, the production manager cautioned that the plant can produce no more than 90,000 units in a quarter. Is this a potential problem? ? If so, what can be done about it
