AutoSave IF OFF A SU Lab 9-CVP Chap 21 LabSheet - Saved to my Mac a Home Insert Draw Design Layout Comments References Mailings Review View Tell me A Ever 21 Share 0 X C Calibri (Bo... v 11 ~ A MaubCcbdte AaBbcodes AaBbCD AaBhccDde AaBb Mabebee Paste BI U JUX X B x Normal Hasting No Spacing = Y Dictate reading Y Styles Pare Sensitivity Name Managerial Accounting Lab #9 Assignment Chapter 21-CVP Spring 2021 Complete the following problems using EXCEL using the accompanying Lab #9 template. Do not handwrite your answers. On your EXCEL spreadsheet you will need to organize your work to match the requirements as stated in the problems. You must label your work and clearly identify your answers. The assignment is due next week as usual. Problem 1 The manager at the Uviewum Classic Cinema is concerned about the impact of the internet on movie attendance. They have hired you to determine the number of movie goers that must view the movie to break even on a film. Each film is played for one month at this theater. When a film is rented Uviewem must pay a $7,000 fee plus 5% of the ticket sales. The admissions price to the movie is $12.00 per person. The mallrents the space to the theater for $3,000 per month. The theater pays a manager/ticket taker $3,200 per month and the concessions workers are paid $ 1,800 per month. Assume that each moviegoer spends $7.00 on concession products and that the cost of the itens consumed is $3.00. Compute the number of paying attendees (our internal control is excellent and there are no freebies) that must view the movie during the month in order to breakeven. a) List and total the fixed costs associated with showing a film at this theater? b) List and total the variable costs associated with each ticket sold? c) What is the contribution margin per ticket sold? d) Compute the number of paying attendees (our Internal control is excellent and there are no freebies) that must view the movie during the month in order to breakeven. Problem 2 Nextel Communications, Inc. is one of the largest digital wireless service providers in the United States. In a recent year, it had 8,666,500 accounts that generated revenues af $7,699,000,000. Costs and expenses were as follows: Cost of revenue $2.869,000,000 Selling, general and administrative expenses 3,020,000,000 Depreciation 1,746,000,000 Assume that 65% of the cost of revenue and 55% of the selling. Eeneral and administrative expenses are Page 1 of 2 509 words English United States) Focus EN + 120% AutoSave OFF OFF HESU Lab 9-CVP Ch 21 Lab Template Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X Calibrl (Body) v 11 ~ Al A General Wrap Text HE Insert v , v Delete Paste BIU 17 Av Av = = = Y Merge & Center Conditional Format Cell Formatting es Table Styles Sort & Filter # Format Find & Select Analyze Data Sensitivity V A1 fx B C C D H I L M N 0 a R S T U Narre: 2 Problem 1 . Fixed costs b. Unit Variable casts 9 d. Movie goersat breakeven 10 11 12 13 c. Contributior marin per ticket 14 15 16 17 12 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 Problem 2 37 Cost of revenue 38 SGA 39 Depreciation 40 Total 41 42 43 :. Break won number of accounts Variable Fixed Total 2,869,000,000 3,020,000,000 1,746,000,000 7.635.000.000 Sheet1 Sheet2 Sheet3 + - + 100% AutoSave IF OFF A SU Lab 9-CVP Chap 21 LabSheet - Saved to my Mac a Home Insert Draw Design Layout Comments References Mailings Review View Tell me A Ever 21 Share 0 X C Calibri (Bo... v 11 ~ A MaubCcbdte AaBbcodes AaBbCD AaBhccDde AaBb Mabebee Paste BI U JUX X B x Normal Hasting No Spacing = Y Dictate reading Y Styles Pare Sensitivity Name Managerial Accounting Lab #9 Assignment Chapter 21-CVP Spring 2021 Complete the following problems using EXCEL using the accompanying Lab #9 template. Do not handwrite your answers. On your EXCEL spreadsheet you will need to organize your work to match the requirements as stated in the problems. You must label your work and clearly identify your answers. The assignment is due next week as usual. Problem 1 The manager at the Uviewum Classic Cinema is concerned about the impact of the internet on movie attendance. They have hired you to determine the number of movie goers that must view the movie to break even on a film. Each film is played for one month at this theater. When a film is rented Uviewem must pay a $7,000 fee plus 5% of the ticket sales. The admissions price to the movie is $12.00 per person. The mallrents the space to the theater for $3,000 per month. The theater pays a manager/ticket taker $3,200 per month and the concessions workers are paid $ 1,800 per month. Assume that each moviegoer spends $7.00 on concession products and that the cost of the itens consumed is $3.00. Compute the number of paying attendees (our internal control is excellent and there are no freebies) that must view the movie during the month in order to breakeven. a) List and total the fixed costs associated with showing a film at this theater? b) List and total the variable costs associated with each ticket sold? c) What is the contribution margin per ticket sold? d) Compute the number of paying attendees (our Internal control is excellent and there are no freebies) that must view the movie during the month in order to breakeven. Problem 2 Nextel Communications, Inc. is one of the largest digital wireless service providers in the United States. In a recent year, it had 8,666,500 accounts that generated revenues af $7,699,000,000. Costs and expenses were as follows: Cost of revenue $2.869,000,000 Selling, general and administrative expenses 3,020,000,000 Depreciation 1,746,000,000 Assume that 65% of the cost of revenue and 55% of the selling. Eeneral and administrative expenses are Page 1 of 2 509 words English United States) Focus EN + 120% AutoSave OFF OFF HESU Lab 9-CVP Ch 21 Lab Template Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X Calibrl (Body) v 11 ~ Al A General Wrap Text HE Insert v , v Delete Paste BIU 17 Av Av = = = Y Merge & Center Conditional Format Cell Formatting es Table Styles Sort & Filter # Format Find & Select Analyze Data Sensitivity V A1 fx B C C D H I L M N 0 a R S T U Narre: 2 Problem 1 . Fixed costs b. Unit Variable casts 9 d. Movie goersat breakeven 10 11 12 13 c. Contributior marin per ticket 14 15 16 17 12 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 Problem 2 37 Cost of revenue 38 SGA 39 Depreciation 40 Total 41 42 43 :. Break won number of accounts Variable Fixed Total 2,869,000,000 3,020,000,000 1,746,000,000 7.635.000.000 Sheet1 Sheet2 Sheet3 + - + 100%