Florida Atlantic University Production Costs Excel Spreadsheet
Description
Using an Excel spreadsheet, calculate the bottom line improvement using the base line below under these scenarios:
- Increase sales by 50%
- Reduce finance costs by 50%, keeping sales at $100,000
- Reduce production costs by 20% (cost of goods sold), keeping sales and finance costs at the initial levels
What option offers the best overall result?
Upload the Excel file with your calculations.
|
Item |
Base Line |
|---|---|
|
Sales |
$100,000 |
|
Cost of goods sold |
$80,000 |
|
Gross margin |
$20,000 |
|
Finance costs |
$6,000 |
|
Subtotal |
$14,000 |
|
Taxes at 25% |
$3,500 |
|
Contribution |
$ 10,500 |
Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."
Complete the 
Complete the order payment after filling in the order form. We’ll receive your order and assign it to a writer.
The assigned writer will complete your paper and forward it to our Editing Team for review and approval.
Once approved by the editor, the completed paper will be uploaded to your account for you to download, review and approve.