Question
Can you please show me the formulas on how to get these answers in excel? 1.Bubba's Steakhouse has budgeted the following costs for a month
Can you please show me the formulas on how to get these answers in excel?
1.Bubba's Steakhouse has budgeted the following costs for a month in which 1,600 steak dinners will be produced and sold: Materials, $4,080; hourly labor (variable), $5,200; rent (fixed), $1,570; depreciation, $760; and other fixed costs, $540. Each steak dinner sells for $13.60 each. How much would Shulas profit increase if 10 more dinners were sold?
2.Stellar Company has the following sales, variable cost, and fixed cost. If sales increase by $10,000 then their profit increases/decreases by how much? Sales $50,000 Variable Costs $7,000 Fixed Costs $29,000
3.Total costs were $79,700 when 28,000 units were produced and $92,500 when 39,000 units were produced. Use the high-low method to find the estimated total costs for a production level of 32,000 units.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started