Shirrell Blackthorn is the accountant for several pizza restaurants based in a tri-city area. The president of the chain wanted some help with budgeting and cost control, so Shirrell decided to analyze the account for the past year. She divided the accounts into four different categories, depending on whether they appear to be primarily fixed or to vary with one of three different drivers. Food and wage costs appeared to vary with the total sales dollars. Delivers costs varied with the number of miles driven (workers were required to use their own cars and were reimbursed for miles driven). A group of other costs, including purchasing, materials handling, and purchases of kitchen equipment, dishes, and pans, appears to vary with the number of different product types (e.g., pizza, salad, lasagna). Shirrell came up with the following monthly averages:
Food and wage costs $175,000
Delivery Costs $18,000
Other costs $9,520
Fixed Costs $255,000
Sales revenue $560,000
Delivery mileage in miles $8,000
Number of product types 14
Required:
1. Calculate the average variable rate for the following costs: food and wages, delivery costs, and other costs.
2. Form an equation for total cost based on the fixed costs and your results from requirement 1.
3. The president is considering expanding the restaurant menu and plans to add on new offering to the menu. According to the cost equation, what is the additional monthly cost for the new offering?