80.2K

Verified Solution

Link Copied!

THIS IS FOR QMB 4680

PART 2-

= Homework: Homework 2 - Sprea... Question 5, 11.6.43 HW Score: 34%, 34 of 100 points O Points: 0 of 15 Save The director of a nonprofit ballet company is planning its next fundraising campaign. In recent years, the program has found the given percentages of donors and gift levels. These were used to develop a spreadsheet model to calculate the total amount donated. Use a one-way data table to show how the amount varies based on the number of solicitations. Click the icon to view the ballet company fundraising model. C!! Fill in the missing values from the one-way data table to show how the amount varies based on the number of solicitations. X ballet company fundraising model B D (Simplify your answers. Type integers or decimals. Do not round. Solicitations Total Donations 500 $ 600 $ 700 $ 800 S 900 S $ 1000 $ $ 1100 $ 1200 $ 1300 $ 1400 $ 1500 $ 1600 $ A 1 Ballet Company 2 3 Gift Level 4 Benefactor 5 Philanthropist 6 Producer's Circle 7 Director's Circle 8 Principal 9 Soloist 0 11 Solicitations 12 13 Total Donations Amount $10,000 $5.000 $1.000 $500 $100 $50 Average Number of Gifts 3 11 24 155 6% 10% of solicitations of solicitations 1,000 $147.500 The Excel formula to find the Total Donations is = (B4*C4)+(B5*C5)+(B6*C6)+(87*C7)+(B8%B11*C8)+(B9*811*09). Print Print Done Help Me Solve This View an Example Ge leck Answer PREVIOUS NEXT = Homework: Homework 2 - Sprea... Question 7, 11.6.47 Part 1 of 5 HW Score: 34%, 34 of 100 points O Points: 0 of 20 Save Use the Markdown Pricing Model spreadsheet model and a two-way data table to find the total revenue if days at full retail vary from 35 to 55 in increments of 5 and the intermediate markdown varies from 10% to 45% in increments of 5%. Click here to view the Markdown Pricing Model spreadsheet model with numbers. Click here to view the Markdown Pricing Model spreadsheet model with Excel functions. C... Fill in the two-way data table below. (Round to the nearest dollar as needed.) Intermediate Markdown Days at 10% full Retail 15% 20% 25% 30% 35% 40% 45% 35 s so SI SO SU SI Markdown pricing model spreadsheet model numbers. B D A 1 Markdown Pricing Model 2 3 Data 4 Retail Price 5 Inventory 6 Selling Season (days) 7 Days at full retail 8 Intermediate markdown 9 Clearance markdown 10 14 Color Mata $70.00 1000 55 40 30% 70% Help Me Solve This View a ar All Check Answer Markdown pricing model spreadsheet model numbers ewa ar All 10 11 Sales Data 12 Price(X) Average Daily Sales 13 $70 7.00 14 $49 32.20 15 Demand function parameters 16 Intercept 91 17 Slope -1.2 18 19 Model 20 21 Full Retail Sales 22 Retail price $70.00 23 Daily sales 7.00 24 Days at retail price 40 25 Units sold at retail 280 26 Retail revenue $19,600.00 27 Discount Sales 28 Discount 30% 29 Discount price $49.00 30 Daily sales 32.20 31 Unit sold 483 32 Discount revenue $23,667.00 33 Clearance Sales 34 Clearance nice 21.00 Print Done Markdown pricing model spreadsheet model numbers 1.2 a ar All Che rupe 18 19 Model 20 21 Full Retail Sales 22 Retail price $70.00 23 Daily sales 7.00 24 Days at retail price 40 25 Units sold at retail 280 26 Retail revenue $19,600.00 27 Discount Sales 28 Discount 30% 29 Discount price $49.00 30 Daily sales 32.20 31 Unit sold 483 32 Discount revenue $23,667.00 33 Clearance Sales 34 Clearance price 21.00 35 Units sold at clearance 237 36 Clearance $4,977.00 revenue 37 38 Total revenue $48,244.00 When using this model, replace the appropriate values in cell A14 and in columns B and C with formulas. Print Done = Homework: Homework 2 - Sprea... Question 5, 11.6.43 HW Score: 34%, 34 of 100 points O Points: 0 of 15 Save The director of a nonprofit ballet company is planning its next fundraising campaign. In recent years, the program has found the given percentages of donors and gift levels. These were used to develop a spreadsheet model to calculate the total amount donated. Use a one-way data table to show how the amount varies based on the number of solicitations. Click the icon to view the ballet company fundraising model. C!! Fill in the missing values from the one-way data table to show how the amount varies based on the number of solicitations. X ballet company fundraising model B D (Simplify your answers. Type integers or decimals. Do not round. Solicitations Total Donations 500 $ 600 $ 700 $ 800 S 900 S $ 1000 $ $ 1100 $ 1200 $ 1300 $ 1400 $ 1500 $ 1600 $ A 1 Ballet Company 2 3 Gift Level 4 Benefactor 5 Philanthropist 6 Producer's Circle 7 Director's Circle 8 Principal 9 Soloist 0 11 Solicitations 12 13 Total Donations Amount $10,000 $5.000 $1.000 $500 $100 $50 Average Number of Gifts 3 11 24 155 6% 10% of solicitations of solicitations 1,000 $147.500 The Excel formula to find the Total Donations is = (B4*C4)+(B5*C5)+(B6*C6)+(87*C7)+(B8%B11*C8)+(B9*811*09). Print Print Done Help Me Solve This View an Example Ge leck Answer PREVIOUS NEXT = Homework: Homework 2 - Sprea... Question 7, 11.6.47 Part 1 of 5 HW Score: 34%, 34 of 100 points O Points: 0 of 20 Save Use the Markdown Pricing Model spreadsheet model and a two-way data table to find the total revenue if days at full retail vary from 35 to 55 in increments of 5 and the intermediate markdown varies from 10% to 45% in increments of 5%. Click here to view the Markdown Pricing Model spreadsheet model with numbers. Click here to view the Markdown Pricing Model spreadsheet model with Excel functions. C... Fill in the two-way data table below. (Round to the nearest dollar as needed.) Intermediate Markdown Days at 10% full Retail 15% 20% 25% 30% 35% 40% 45% 35 s so SI SO SU SI Markdown pricing model spreadsheet model numbers. B D A 1 Markdown Pricing Model 2 3 Data 4 Retail Price 5 Inventory 6 Selling Season (days) 7 Days at full retail 8 Intermediate markdown 9 Clearance markdown 10 14 Color Mata $70.00 1000 55 40 30% 70% Help Me Solve This View a ar All Check Answer Markdown pricing model spreadsheet model numbers ewa ar All 10 11 Sales Data 12 Price(X) Average Daily Sales 13 $70 7.00 14 $49 32.20 15 Demand function parameters 16 Intercept 91 17 Slope -1.2 18 19 Model 20 21 Full Retail Sales 22 Retail price $70.00 23 Daily sales 7.00 24 Days at retail price 40 25 Units sold at retail 280 26 Retail revenue $19,600.00 27 Discount Sales 28 Discount 30% 29 Discount price $49.00 30 Daily sales 32.20 31 Unit sold 483 32 Discount revenue $23,667.00 33 Clearance Sales 34 Clearance nice 21.00 Print Done Markdown pricing model spreadsheet model numbers 1.2 a ar All Che rupe 18 19 Model 20 21 Full Retail Sales 22 Retail price $70.00 23 Daily sales 7.00 24 Days at retail price 40 25 Units sold at retail 280 26 Retail revenue $19,600.00 27 Discount Sales 28 Discount 30% 29 Discount price $49.00 30 Daily sales 32.20 31 Unit sold 483 32 Discount revenue $23,667.00 33 Clearance Sales 34 Clearance price 21.00 35 Units sold at clearance 237 36 Clearance $4,977.00 revenue 37 38 Total revenue $48,244.00 When using this model, replace the appropriate values in cell A14 and in columns B and C with formulas. Print Done

Answer & Explanation Solved by verified expert

See Answer