Question: please fill out the blank excel sheet. thanks EXERCISE 4-4 Changes in Variable Costs, Fixed Costs, and Volume 004) Information for Drone On Limited is

please fill out the blank excel sheet. thanksEXERCISE 4-4 Changes in Variable Costs, Fixed Costs, and Volume 004) Information for Drone On Limited is shown below: Percentage of Sales Per Unit S1.000 800 $ 200 100% 80% Selling price Variable expenses Contribution margin 20% Total fixed expenses are $100,000 per month, and Drone On Limited is selling 1,000 drones per month Required: Page 121 1. The marketing manager argues that a $5,000 increase in the monthly budget to prepare webinars would increase monthly sales by 50 drones. Should the webinar budget be increased? 2. Refer to the original data. Management is considering using higher quality components that would increase the variable cost by $80 per unit. The marketing manager believes the higher quality product would increase sales by 15% per month. Should the higher quality components be used? Exercise 4-4 Part 1 Current Proposed Change Sales volume (in units) Per Unit Total Per Unit Total Sales Variable expenses Contribution margin Fixed expenses Operating income Do it Part 2 Proposed Change Current 1,000 Sales volume (in units) Per Unit Tota Sales Variable expenses Contribution margin Fixed expenses Operating income Per Unit Total $ 1,000 $1,000,000 800 800,000 $ 200 200,000 100,000 $ 100,000
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
