50.1K

Verified Solution

Link Copied!

4. please fill in all boxes. please read the questionumbers carefully! similar questions may already be posted to Chegg but they have slightly different numbers. i will give upvote/thumbs up for correct answer! thank you for your help!

The Orwell store of Carlson Mart, a chain of small neighborhood convenience stores, is preparing its activity-based budget for January 2018. Carlson Mart has three product categories: soft drinks ( 35% of cost of goods sold [COGS]), fresh produce ( 25% of COGS), and packaged food ( 40% of COGS). The following table shows the four activities that consume indirect resources at the Orwell store, the cost drivers and their rates, and the cost-driver amount budgeted to be consumed by each activity in January 2018. (Click the icon to view the activity and cost-driver information.) \begin{tabular}{|c|c|c|c|c|c|} \hline \multirow[b]{3}{*}{ Activity } & \multirow[b]{3}{*}{ Cost Driver } & \multirow{2}{*}{\begin{tabular}{c} January 2018 \\ Budgeted \\ Cost-Driver \end{tabular}} & \multicolumn{3}{|c|}{\begin{tabular}{c} January 2018 Budgeted \\ Amount of Cost Driver Used \end{tabular}} \\ \hline & & & Soft & Fresh & Packaged \\ \hline & & Rate & Drinks & Snacks & Food \\ \hline Ordering & Number of purchase orders & 88 & 16 & 24 & 16 \\ \hline Delivery & Number of deliveries & 76 & 9 & 61 & 22 \\ \hline Shelf-stocking & Hours of stocking time & 16.00 & 17 & 178 & 96 \\ \hline Customer support & Number of items sold & 0.20 & 4,500 & 34,300 & 10,500 \\ \hline \end{tabular} Requirement 1 . What is the total budgeted indirect cost at the Athens store in January 2018 ? What is the total budgeted cost of each activity at the Athens store for January 2018 ? What is the budgeted indirect cost of each product category for January 2018? Complete the following table to determine the total budgeted indirect cost, total budgeted cost of each activity, and budgeted indirect cost of each product category for January 2018. (Round the percentages to the nearest hundredth percent, X.XX\%.) \begin{tabular}{|c|c|c|c|c|} \hline & \begin{tabular}{c} Soft \\ Drinks \\ \end{tabular} & \begin{tabular}{c} Fresh \\ Snacks \end{tabular} & \begin{tabular}{c} Packaged \\ Food \end{tabular} & Total \\ \hline Ordering & & & & \\ \hline Delivery & & & & \\ \hline Shelf-stocking & & & & \\ \hline Customer support & & & & \\ \hline Total costs & & & & \\ \hline Percentage of total indirect costs & % & % & % & \\ \hline \end{tabular}

Answer & Explanation Solved by verified expert

See Answer