only need the blanks

Pawsh operates a pet supply superstore in Atlanta with three main product Store manager Jordan Baxter gathers the following information regarding lines: food, toys, and accessories, Pawsh allocates common selling, the three product lines: general, and administration (SG&A) costs to each product line using the Click the icon to view the product line information) cost of merchandise of each product line. Department manager salaries, while considered SG&A, are direct and are assigned directly to each For 2020, Pawsh budgets the following selling, general, and product line. The company wants to optimize the pricing and cost administration costs: management of each product line and is wondering whether its accounting Click the icon to view the selling, general, and administration costs.) system is providing it with the best information for making such decisions Calculate the each of the cost driver rates need to allocato common SG&A costs under the method you have identified for this requirement. (Round all dollar amounts to the nearest cent, $XXX. Enter any rates as a percentage to two decimal places, XXX) Cost driver rate Purchasing Receiving Selling Rent Store manager's salary Utilities Start by determining the total selling, general, and administrativo (SG&A) expenses allocated to each department and in total when allocating common SG&A expenses using the cost drivers you identified above. (Use the cost driver rate amounts you determined in the preceding step for your allocation computations. Round all amounts you enter into the table below to the nearest whole dollar) Food Toys Accessories Total Direct SG&A costs: Department manager salaries Common SG&A costs allocated: Purchasing department expense Receiving department expenso Selling expense Ront Store manager's salary Utilities + Cost Number of departments alary Operating income ng the to Total quantity of cost driver G&A e ca und all amounts you encei MU ule tavle veluw w the n sing the ocate common SG&A costs under the method you have identified for this requirement. (Rc rates as a percentage to two decimal places, X.XX.) Cost driver rate + 11 11 II + % of revenue $ 11 11 per box ng cc ur allo administrative (SG&A) expenses allocated to each depa per department ed above. (Use the cost driver rate amounts you determii etable below to the nearest whole dollar.) per purchase order Food Toys Accessories 1 per square foot US Start by determining the total selling general, and administrative (SG&A) expenses allocated to each department and in total when allocating common SG&A expenses using the cost drivers you identified above. (Use the cost driver rate amounts you determined in the preceding step for your allocation computations. Round all amounts you enter into the table below to the nearest whole dollar) Food Toys Accessories Total Direct SG&A costs: Department manager salaries Common SG&A costs allocated: Purchasing department expense Receiving department expense Seling expense Rent Store manager's salary Utilities Total SGEA In this step, prepare an income statement for Pawsh, by product line and in total, allocating common SG&A expenses using the method you proposed in this requirement . In the following step calculate the profit per square foot of store space for each product line. (Use parenthesos or a minus sign to enter losses. Round the profit (los) per square foot to the nearest cent, $X.XX.) Pawsh Budgeted Income Statement For the Year Ended December 31, 2020 Food Toys Accessories Ravenues Total Cost of merchandise Gross margin Selling, general, & administrative costs 00 00 bo In this step, prepare an income statement for Pawsh, by product line and in total, allocating common SG&A expenses using the method you proposed in this requirement . In the following step calculate the profit per square foot of store space for each product line. (Use parentheses or a minus sign to enter losses. Round the profit (loss) per square foot to the nearest cent, $X.XX.) Pawsh Budgeted Income Statement For the Year Ended December 31, 2020 Food Toys Accessories Total Revenues Cost of merchandise Gross margin Selling general, & administrative costs Operating income (osa) Square feet of store space Profit (loss) per square foot Compare your results to the results in requirement 1 on a profitloss per square foot basis. Review the income statement from requirement1 Comparing the product line income statements in requirements 1 and 2, it appears that is/are more profitable per square foot and is/are less profitable per square foot under the system used in requirement 2 compared to the simple system. Those and Review the income statement from requirement 1 Comparing the product line income statements in requirements 1 and 2 it appears that is/are more profitable per square foot is/are less profitable per square foot under the system used in requirement 2 compared to the simple system. These results are The reason is that the departments use Requirement 3. What recommendations would you make to the store manager based on the results of the activity-based costing analysis? The recommendation is that the organization switch to method. With this method, the product lines are assigned Indirect costs based on their The current accounting technique because it V. By adopting management can evaluate the costs of operating the three product lines and make more informed pricing and product mix decisions Requirement 1. Prepare an income statement for Pawsh, by product line and in total, allocating common SG&A expenses using cost of merchandise. Calculate the profit per square foot of store space for each product line. Start by determining the total selling, general, and administrative (SG&A) expenses allocated to each department and in total when allocating common SG&A expenses using cost of merchandise. Food Toys Accessories Total Direct SG&A costs: Department manager salaries 44000 70000 54000 168000 797576 598182 598182 1993940 Common SG&A costs allocated 841576 668182 652182 Total SGRA 2161940 In this step, prepare an income statement for Pawsh, by product line and in total, allocating common SG&A expenses using cost of merchandise. In the following step calculate the profit per square foot of store space for each product line. (Use parentheses or a minus sign to enter losses. Round the profit (loss) per square foot to the nearest cent, $X.XX.) Pawsh Budgeted Income Statement For the Year Ended December 31, 2020 Food Toys Accessories Total Revenues 3060000 2295000 2295000 7650000 1800000 Cost of merchandise 1350000 1350000 4500000 Gross margin 4860000 3645000 3645000 12150000 797576 598182 598182 1993940 Selling, general, & administrative costs 4062424 3046818 3046818 10156060 Operating incomo (losa) Square feet of store space 11900 2900 5000 341.38 1050.63 Prolit (loss) per square foot 609.36 Requirement 2. Identify an improved method for allocating costs to the three product lines. Explain. Use the method for allocating SG&A costs that you propose to prepare new product-line Income statements Calculate the profit per square foot of store space for each product line. Compare your results Square feet of store space Profit (loss) per square foot Compare your results to the results in requirement 1 on a profit loss per square foot basis. Review the income statement from requirement 1 Comparing the product line income statements in requirements 1 and 2, it appears that and is/are less profitable per square foot under the system use results are The reason is that the departments use is/are more profitable pe e simple syster Food and Accessories posting analysis Requirement 3. What recommendations would you make to the store manager based only Food oduct lines are The recommendation is that the organization switch to indirect costs based on their only Toys because it By adopting management can evalue Compare your results to the results in requirement 1 on a profit/loss per squ Review the income statement from requirement 1. Comparing the product line income statements in requirements 1 and 2, it ap and is/are less profitable per square foot under the resul hat the departments use Reqi is would you make to the store manag only Food The zation switch to indire only Toys Food and Accessories because onorati ofit/loss per square foot basis. ents 1 and 2, it appears that is/are more profitable per square foot are foot under the system used in requirement 2 compared to the simple system. These s use to the differing amounts of SG&A resources relative to its merchandise costs the same amount of SG&A resources relative to its merchandise costs management can evaluate the costs of ting erchandise rgin eneral, & administrative costs income (loss) Bet of store space ss) per square foot your results to the results in requirement 1 on Rhe income statement from requirement 1. a broad costing a process costing is/are more profital ament 2 compared to the simple -ing the product line income statements in requis is/are less profitable pers The reason is that the departmi a simple costing are an activity-based costing (ABC) ts of the activity-based costing a rement 3. What recommendations would you ma sky method. With this method, the product lin The current accounting technique ecommendation is that the organization switch to ct costs based on their because it Rv adopting management ca ministrative costs oss) space are foot its to the results in requirement 1 on a profit/loss per square foot basis. statement from renuiromont 1 duct line ir uireme consumption of the activities that give rise to the costs Ther asults relative cost of merchandise What recom relative sales revenue id. Wit ation is that t The current ac used on their because it antina Food Toys Accessories evenues ost of merchandise Eross margin Selling, general, & administrative costs Il Operating income (loss) Square feet of store space Profit (loss) per square foot Compare your results to the results in requirement 1 on a profit/loss per square foot basis. Review the income statement from requirement 1. ears that ystem used in requirem masks the lower cost of merchandise of one or more departments ar based on the results masks the lower profitability of one or more departments method. Wit! masks the lower revenues of one or more department The current acc because it By adopting nnorating the three product lines and make more informed pricing and product mix decisions. 1 on a profit/loss per square foot basis. e profitar simples requirements 1 and 2, it appears that per square foot under the system used in rec Dartments use ABC broad costing osting ar ou make to the store manager based on the re metho process costing duct line tch to The curr simple costing because it management can V. By adopting ion Total For the Year Ended Food Toys Accessories Revenues Cost of merchandise Gross margin Selling, general, & administrative costs Operating income (loss) Square feet of store space Profit (loss) per square foot Compare your results to the results in requirement 1 on a profit/loss per square foot basis. Review the income statement from requirement 1. Comparing the product line income statements in requirements 1 and 2, it appears that and is/are less profitable per square foot under the system used in requirement 2 come results are The reason is that the departments use he results of the acti ethod. With this me current accounting accurately considers the activity usage assumes all indirect costs are driven by the dollar amount of merchandise sold By adopting hoduct lines and make more informed pricing and product mix decisions