Question: DA 2 2 . 1 Data visualization can be used to compare income effects of short - term decisions. For this case, you will use

DA 22.1 Data visualization can be used to compare income effects of short-term decisions.
For this case, you will use an approach similar to that used in the DA5.1 example. You will help a fast food restaurant evaluate the benefits of installing a kiosk in the lobby to automate customer orders, thus reducing the need for cashiers. This case requires you to compare income statement data for traditional and digital ordering for the restaurant, and then create and analyze a bar chart. Presented here are budgeted income statements for a small fast food restaurant. Traditionally, customers order face-to-face by telling the cashier the items they wish to purchase. In a digital system, customers order and use a credit or debit card to pay at the kiosk, reducing the need for cashiers. The company is contemplating changing to a digital ordering system with kiosks in the lobby.
Comparative budgeted income statements using traditional and digital ordering are provided here.
Income statement data for a traditional and a digital ordering system
Revenue
Cost of goods sold
Cashier labor
Other variable costs
Contribution margin
Depreciation
Other fixed costs
Net operating income
Traditional
Digital Ordering
Ordering
$450,000
$450,000
190,000
190,000
84,000
19,600
18,000
18,000
158,000
222,400
43,000
103,000
45,000
45,000
$70,000
$74,400
Use Excel or the visualization software of your or your instructor's choice to perform the following. There are four parts to this problem.
a.
b.
C.
In the template provided, calculate the comparative income statement amounts for the digital and traditional ordering systems assuming an increase in revenue volume of 25%.
Create a bar chart showing the income statement components for the traditional and digital ordering systems that includes amounts both with and without the 25% revenue increase. Include a descriptive chart title, axes labels, axes formatting, and a legend.
By combining the income statement data with and without the revenue volume changes, it is easier to compare the changes in costs and operating income.
Under which model does net operating income appear to increase more when volume increases? What costs changed to create the effect on operating income?
Briefly explain why this occurs.
d.
Identify other factors might you need to consider when increasing volume with a digital versus a traditional face-to-face ordering system.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!