Dv C5 File LD 6 7 00 11 12 13 Home 1 2 Jay Corporation has decided to prepare contribution income statements for internal planning. 3 4 Budgeted information for Quarter 1 of 2024: 5 Sales in units 30 Sales price per unit 37 38 M Quarter 1 Quarter2 Quarter 3 Quarter 4 x fx After analyzing expenses, the company has determined the following cost patterns. 9 Cost of Goods Sold (per unit) $29.00 Sales Commissions (per dollar of sales) 9.50% Administrative Salaries (per quarter) Rent Expense (per quarter) Depreciation Expense (per quarter) Quarter 1 Quarter2 Quarter 3 Quarter 4 Insert Draw Calibri (Body) 15 Shipping has been determined to be a mixed cost with the following total costs and units: 16 17 2022 18 19 20 21 22 2023 23 24 25 26 27 28 Use the data to answer the following. 29 = High level of activity Low level of activity Change in activity AAB I 17,000 $48.00 Graded Worksheet $45,000 $27,000 $36,000 Calculation Mode: Automatic Workbook Statistics Total Cost 31 32 1. Using the high-low method, determine a cost formula for shipping costs. 33 34 35 36 $67,000 $94,000 $89,800 $92,600 $72,500 $80,000 $84,000 $100,000 (Use cells A4 to C26 from the given information to complete this question. All answers should be inp Total Cost Units $100,000 67,000 $33,000 12,500 21,000 13,800 20,000 13,700 14,000 14,300 22,500 Units D 22,500 12,500 10,000

Jay Corporation has decided to prepate contribution income statements for internal planning After analvaine eoenses, the company has determined the following cost patterns: 5 Shipping has been determined to be a mixed cort with the following total costs and units: Use the dsta to answer the following (Use cells A4 to C25 trom the given inlormution to complete this question, Ail answers should be ing 1. Using the hiph-low method, determise a cost formula for shipping costs 58>6 A. b c. \begin{tabular}{|l|r|} \hline Budgeted information for Ougnter fol 2024 & \\ \hline Sales in units & 17,000 \\ \hline SSles price per unit & 548.00 \\ \hline \end{tabular} \begin{tabular}{|c|c|} \hline Cont of Goods Sold loet unit & 529.90 \\ \hline 5Bies Commidsions (per dollar of sales) & 950 \\ \hline Administrative Salents (per quaner) & \\ \hline Rent Expense (per quartes) & 522,000 \\ \hline Depreciation Espense iper quartien & 356,000 \\ \hline \end{tabular} 5 Shipping has been determines to be a mived cost wh tre following topal cons and inits: \begin{tabular}{|c|c|c|} \hline 2022 & Istricost & Units \\ \hline Quanter 1 & 587000 & 12500 \\ \hline Quarter2 & 394000 & 21,000 \\ \hline Quartier 3 & 589300 & \\ \hline Ouane 4 & 592600 & 20,000 \\ \hline 2023 & & \\ \hline Quorter 1 & 512500 & 25,700 \\ \hline Quarter? & 580,000 & 14000 \\ \hline Quarter 3 & 364,000 & 14,900 \\ \hline Quenter 4 & 5100000 & 22500 \\ \hline \end{tabular} Uae the data t5 answer the following: BGradedWorksheet 22c IUSe cels AA to L 0 rrom the given intormanon to compiete this quesoon. All answers snou 1. Using the high-low method, determine a cost formula for shipping costs. 6. 2. Prepare a contributon margin income statement for Quarter 1 of 2024 . 58>6 A. b c. \begin{tabular}{|l|r|} \hline Budgeted information for Ougnter fol 2024 & \\ \hline Sales in units & 17,000 \\ \hline SSles price per unit & 548.00 \\ \hline \end{tabular} \begin{tabular}{|c|c|} \hline Cont of Goods Sold loet unit & 529.90 \\ \hline 5Bies Commidsions (per dollar of sales) & 950 \\ \hline Administrative Salents (per quaner) & \\ \hline Rent Expense (per quartes) & 522,000 \\ \hline Depreciation Espense iper quartien & 356,000 \\ \hline \end{tabular} 5 Shipping has been determines to be a mived cost wh tre following topal cons and inits: \begin{tabular}{|c|c|c|} \hline 2022 & Istricost & Units \\ \hline Quanter 1 & 587000 & 12500 \\ \hline Quarter2 & 394000 & 21,000 \\ \hline Quartier 3 & 589300 & \\ \hline Ouane 4 & 592600 & 20,000 \\ \hline 2023 & & \\ \hline Quorter 1 & 512500 & 25,700 \\ \hline Quarter? & 580,000 & 14000 \\ \hline Quarter 3 & 364,000 & 14,900 \\ \hline Quenter 4 & 5100000 & 22500 \\ \hline \end{tabular} Uae the data t5 answer the following: BGradedWorksheet 22c Jay Corporation has decided to prepate contribution income statements for internal planning After analvaine eoenses, the company has determined the following cost patterns: 5 Shipping has been determined to be a mixed cort with the following total costs and units: Use the dsta to answer the following (Use cells A4 to C25 trom the given inlormution to complete this question, Ail answers should be ing 1. Using the hiph-low method, determise a cost formula for shipping costs