Benicio wants to compare the sales of each product in 2021 with the sales in 2020. He has the 2020 sales data stored in a separate workbook. Add the 2020 sales data to the All Locations worksheet as follows:. a. Open the workbook Support_EX19_CS5-8a_2020.xlsx.
b. Return to the All Locations worksheet in the original workbook.
c. In cell G5, enter a formula using an external reference to display the total sales of Mini products in 2020 (cell F5).
d. In the formula in cell G5, change the absolute reference to a mixed reference, with a relative reference to the row number.
e. Fill the range G6:G8 with the formula in cell G5, filling without formatting.
f. Close the workbook Support_EX19_CS5-8a_2020.xlsx.

Jurvin enterprises is a manufacturing company that had no beginning inventories. a subset of the transactions that it recorded during a recent month is shown below. $76,700 in raw materials were purchased for cash. $71,400 in raw materials were used in production. of this amount, $66,300 was for direct materials and the remainder was for indirect materials. total labor wages of $151,700 were incurred and paid. of this amount, $134,300 was for direct labor and the remainder was for indirect labor. additional manufacturing overhead costs of $126,300 were incurred and paid. manufacturing overhead of $126,800 was applied to production using the company's predetermined overhead rate. all of the jobs in process at the end of the month were completed. all of the completed jobs were shipped to customers. any underapplied or overapplied overhead for the period was closed to cost of goods sold.required: 1. post the above transactions to t-accounts.2. determine the cost of goods sold for the period.

howard, fine, & howard is an advertising agency. the firm uses an activity-based costing system to allocate overhead costs to its services. information about the firm's activity cost pool rates follows: stooge company was a client of howard, fine, & howard. recently, 7 administrative assistant hours, 3 new ad campaigns, and 8 meeting hours were incurred for the stooge company account. using the activity-based costing system, how much overhead cost would be allocated to the stooge company account?

The stock of grommet corporation, a u.s. company, is publicly traded, with no single shareholder owning more than 5 percent of its outstanding stock. grommet owns 95 percent of the outstanding stock of staple inc., also a u.s. company. staple owns 100 percent of the outstanding stock of clip corporation, a canadian company. grommet and clip each own 50 percent of the outstanding stock of fastener inc., a u.s. company. grommet and staple each own 50 percent of the outstanding stock of binder corporation, a u.s. company. which of these corporations form an affiliated group eligible to file a consolidated tax return?