- Assignment 12 Warhawk Company Produces Televisions The Following Table Contains Monthly Data Regarding Warhawk S Manufa 1 (45.45 KiB) Viewed 47 times
- Assignment 12 Warhawk Company Produces Televisions The Following Table Contains Monthly Data Regarding Warhawk S Manufa 2 (42.67 KiB) Viewed 47 times
Assignment 12 Warhawk
Company produces televisions. The following table contains monthly data regarding Warhawk's manufacturing costs, production volumes, machine hours, and direct labor hours. Total Month Manufacturing Costs Juary $1,709,550 February $1,706,550 March $1,667,130 April $2,647,000 May $191,0 June $1,907,000 July $1,785,650 August $1,549,750 September $19,350 October $1,904,000 November $1,966,330 December $1,596,150 produced 13,800 13.350 12,750 14,750 14,330 11.990 13,850 12.530 12,980 14,256 13,950 Number of machine bours 15,000 11.250 10,150 7,500 10,500 11.250 K.250 11,150 10,500 12,750 1. Enter the above data in a worksheet. a. Convert the data to a Table. Number of direct labor bours 1,500 2,100 2,400 5,400 LIND 3,600 2,100 Requirements: Complete requirements 1-5 (except for Lai) on a single worksheet. Requirements 6-8 will be completed on a second worksheet. 1,800 2,560 1,100 3,000 4. Add a Field named MH per Television. i. Copy the table that you just created in part la to a new worksheet for use with requirements 6-8. 2. Change the Table name to: Televisions. a. Sort the records in ascending order based on the number of televisions produced. 3. Add a Field named Average Cost. a. Add a formula in the Average Cost field that calculates. the average cost per television. i. The formula must use Field Names. a. Add a formula in the MH per Television Field that calculate the average machine hours per television. i. The formula may NOT use Field Names. 5. Use Table Functions to determine the following: a. The total manufacturing costs for the months with at least 2,000 but less than 3,000 direct labor hours. b. The minimum average cost per television for the months when less than 13,000 televisions are produced. Use the worksheet you that created in part 1.a.i above to complete requirements 6-8. 6. Filter the table to only show records with less than 2,500 direct labor hours. 7. Create the Total Row. Complete items a-d using the Total Row tools (do NOT write your own formulas). a. In the Total Manufacturing Costs column of the Total Row, determine the smallest Total Manufacturing Costs in a month. b. In the Televisions produced column of the Total Row, calculate the total televisions produced for the year. c. In the Number of machine hours column of the Total Row, calculate the average number of machine hours used. d. In the Number of direct labor hours column of the Total Row, calculate the largest number of direct labor hours used in a month. 8. Change the table to a different Table Style than you used in part 1.a.
July $1,785,650 August $3,549,750 September $1,696,350 October $1904,000 November $1,906,530 December $1,596,150 13,830 12.330 12,980 14,250 13,990 13,150 11,250 7,900 8,250 13,150 10,500 12,750 2.100 1,800 2.560 3,160 3,600 1,200 Requirements: Complete requirements 1-5 (except for 1.a.i) on a single worksheet. Requirements 6-8 will be completed on a second worksheet. 1. Enter the above data in a worksheet. a. Convert the data to a Table. i. Copy the table that you just created in part la to a new worksheet for use with requirements 6-8. 2. Change the Table name to: Televisions. a. Sort the records in ascending order based on the number of televisions produced. 3. Add a Field named Average Cost. a. Add a formula in the Average Cost field that calculates the average cost per television. i. The formula must use Field Names. 4. Add a Field named MH per Television. a. Add a formula in the MH per Television Field that calculate the average machine hours per television. i. The formula may NOT use Field Names. 5. Use Table Functions to determine the following: a. The total manufacturing costs for the months with at least 2,000 but less than 3,000 direct labor hours. b. The minimum average cost per television for the months when less than 13,000 televisions are produced. Use the worksheet you that created in part 1.a.i above to complete requirements 6-8. 6. Filter the table to only show records with less than 2,500 direct labor hours. 7. Create the Total Row. Complete items a-d using the Total Row tools (do NOT write your own formulas). a. In the Total Manufacturing Costs column of the Total Row, determine the smallest Total Manufacturing Costs in a month. b. In the Televisions produced column of the Total Row, calculate the total televisions produced for the year. e. In the Number of machine hours column of the Total Row, calculate the average number of machine hours used. d. In the Number of direct labor hours column of the Total Row, calculate the largest number of direct labor hours used in a month. 8. Change the table to a different Table Style than you used in part 1.a. There are NO user input cells in this problem. Remember to follow all items in the Excel Requirements document.