60.1K

Verified Solution

Link Copied!

Step Instructions 1 1. Use the simple costing systemito prepare a product-line profitability report for FS. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions/Productineinfo tabs or if you type the numbers in, you will be marked wrong.) 2 2. Use the ABC system to prepare a product-line profitability report for FS. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions/Productlineinfo tabs or if you type the numbers in, you will be marked wronq.) balced goods, mile and fruit juice, and frozen foods. It identifies four acthities and their activity cost rates as foliows: \begin{tabular}{|l|c|} \hline Ordering & \\ \hline Detivery and receipt of merchandise & $95 per purchase order \\ \hline Shell-stocking & $76 per deliver \\ \hline Customer support and assistance & $19 per hour \\ \hline \end{tabular} The revenues, cost of goods sold, store support costs, activities that account for the store support costs, and activity-ares usage of the three product lines can be found on the "PRODUCTUNEINFO" tab. Use the blue shaded areas on the ENTERANSWERS tab for inputs. Aways use cell references and formulas where appropriate to receive full credit. If you copy/paste from the instructions/Productiineinfo tabs or if you type the numbers in, you will be marked wrong. Pequirements 1 Use the simple costing system to prepare a product-line profitability report for Fitzgerald Supermarkets. a. Enter ali amounts as positive values. DO NQT use paren theres or a minus sign for amounts to be subtracted. 2 Use the ABC system to prepare a product-line profitability report for Fitagerald Supermarkets. a. Enter all amounts as pesitive values. DO NOT use parentheres or a minus sign for amounts to be subtracted. Saving \& Submitting Solution 1 Save file to desktop. a. Create folder on desktop, and Iabel COMPLETED EXCEL PROIECTS 2 Upioad and submit your file to be graded. a. Navgate back to the axtivity window-screea where you dawnloaded the initial s preadsheet b. Cick Choose button under step 3; locate the flle you just saved and click Open c. Cick Uplaad buttan under step 3 d. Cick Suberit buttan under step 4 Viewing Results 1 Cick on Results tah in MyAccountinglab 2 Cick on the Assignment you were working on 3 Cick on Project link; tha will bring up yeur Score Summary 4 Within Score Summary window, click on Download (upper right) to download the spreadsheet with feedback The revenues, cost of goods sold, store support costs, activities that account for the store support costs, and activity-area usage of the three product lines are as follows: Under its simple costing system, Fitzgeraid Supermarkets allocated support costs to products at the rate of 308 of cost of goods soid. 1. Use the simple costing system to prepare a product-line profitabllity report for Fitrgerald Supermarkets. Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the instructions/Productiineinfo tabs or if you type the numbers in, you will be marked wrong.) 2. Use the ABC system to prepare a product-line profitability report for Fitagerald Supermarkets. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions/Productlineinfo tabs or if you type the numbers in, you will be marked wrone.) Step Instructions 1 1. Use the simple costing systemito prepare a product-line profitability report for FS. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions/Productineinfo tabs or if you type the numbers in, you will be marked wrong.) 2 2. Use the ABC system to prepare a product-line profitability report for FS. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions/Productlineinfo tabs or if you type the numbers in, you will be marked wronq.) balced goods, mile and fruit juice, and frozen foods. It identifies four acthities and their activity cost rates as foliows: \begin{tabular}{|l|c|} \hline Ordering & \\ \hline Detivery and receipt of merchandise & $95 per purchase order \\ \hline Shell-stocking & $76 per deliver \\ \hline Customer support and assistance & $19 per hour \\ \hline \end{tabular} The revenues, cost of goods sold, store support costs, activities that account for the store support costs, and activity-ares usage of the three product lines can be found on the "PRODUCTUNEINFO" tab. Use the blue shaded areas on the ENTERANSWERS tab for inputs. Aways use cell references and formulas where appropriate to receive full credit. If you copy/paste from the instructions/Productiineinfo tabs or if you type the numbers in, you will be marked wrong. Pequirements 1 Use the simple costing system to prepare a product-line profitability report for Fitzgerald Supermarkets. a. Enter ali amounts as positive values. DO NQT use paren theres or a minus sign for amounts to be subtracted. 2 Use the ABC system to prepare a product-line profitability report for Fitagerald Supermarkets. a. Enter all amounts as pesitive values. DO NOT use parentheres or a minus sign for amounts to be subtracted. Saving \& Submitting Solution 1 Save file to desktop. a. Create folder on desktop, and Iabel COMPLETED EXCEL PROIECTS 2 Upioad and submit your file to be graded. a. Navgate back to the axtivity window-screea where you dawnloaded the initial s preadsheet b. Cick Choose button under step 3; locate the flle you just saved and click Open c. Cick Uplaad buttan under step 3 d. Cick Suberit buttan under step 4 Viewing Results 1 Cick on Results tah in MyAccountinglab 2 Cick on the Assignment you were working on 3 Cick on Project link; tha will bring up yeur Score Summary 4 Within Score Summary window, click on Download (upper right) to download the spreadsheet with feedback The revenues, cost of goods sold, store support costs, activities that account for the store support costs, and activity-area usage of the three product lines are as follows: Under its simple costing system, Fitzgeraid Supermarkets allocated support costs to products at the rate of 308 of cost of goods soid. 1. Use the simple costing system to prepare a product-line profitabllity report for Fitrgerald Supermarkets. Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the instructions/Productiineinfo tabs or if you type the numbers in, you will be marked wrong.) 2. Use the ABC system to prepare a product-line profitability report for Fitagerald Supermarkets. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions/Productlineinfo tabs or if you type the numbers in, you will be marked wrone.)

Answer & Explanation Solved by verified expert

See Answer