HomeworkLib
Question

You calculate that the fixed costs for the Saco Atlantic Truffle are $25,000 per month and...

You calculate that the fixed costs for the Saco Atlantic Truffle are $25,000 per month and each box costs $25 for the labor, candy, packaging and shipping. Will profits go up or down as a result of the price cut? By How much? (Profits are revenue minus all costs.) I need a formula for Excel to enter all numbers in one cell please help format the following:

(70000 * 51) (70000 *25) - 25000 = 1795000 (70000 * 46) (70000 * 25) - 25000 = 1550000 1795000 - 1550000 = 245000 245000 * 6 = 1470000

business   finance   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

The formula to be written in the excel cell is as below to get the desired answer:

=(((70000*51)-(70000*25)-25000)-((75000*46)-(75000*25)-25000))*6

The answer will be 1470000.

0 0
Add a comment
Know the answer?
Add Answer to:
You calculate that the fixed costs for the Saco Atlantic Truffle are $25,000 per month and...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • 2.   Peter Hill, the 19 year old son of the owner, says that there wasn’t enough...

    2.   Peter Hill, the 19 year old son of the owner, says that there wasn’t enough time in the experiment. He estimates that in the second month, June, Saco Atlantic Truffle will sell 80,000 boxes at $46.00 per box. Please answer the following assuming that Peter is correct. You want to get an idea of what will happen to profits before you commit to an action and make a projection. If profits are projected to go up assuming that Peter...

  • Analysis of Pricing: You manage The Atlantic Taffy Company which makes a saltwater taffy bar for sale to gift shops from Atlantic City, New Jersey, to Mount Desert Island near Bar Harbor Maine. The c...

    Analysis of Pricing: You manage The Atlantic Taffy Company which makes a saltwater taffy bar for sale to gift shops from Atlantic City, New Jersey, to Mount Desert Island near Bar Harbor Maine. The company sells individually wrapped bars in boxes of 50 for $81.00 each. The candies retail for $3.99 for an individual bar and sales have been strong. The owners of the Atlantic would like to increase its sales and profits. They know that, if price is lowered,...

  • Start-up costs: 1) The Boulevard Mall charges you $2,500 rent per month, which includes utilities, telephone,...

    Start-up costs: 1) The Boulevard Mall charges you $2,500 rent per month, which includes utilities, telephone, cleaning, and maintenance. You estimated that 90% of the rent was related to factory operations and 10% was related to selling and administrative activities. 2) You order white, cotton t-shirts from a T-shirt wholesaler. Each T-shirt costs (including taxes, shipping, and handling) $3.75 to purchase. 3) To store T-shirts that were bought, but not yet imprinted, you rent a storage unit. The storage unit...

  • Lantana Company has provided you with the transactions that occurred during its first month of operations....

    Lantana Company has provided you with the transactions that occurred during its first month of operations. The Controller has already recorded the transactions to the T-Accounts and has asked you to prepare the classified balance sheet based on the T-Account balances. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if in...

  • Lantana Company has provided you with the transactions that occurred during its first month of operations....

    Lantana Company has provided you with the transactions that occurred during its first month of operations. The Controller has already recorded the transactions to the T-Accounts and has asked you to prepare the classified balance sheet based on the T-Account balances. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if in...

  • fill in the yellow shaded area with the formulas only. All answers must be entered as...

    fill in the yellow shaded area with the formulas only. All answers must be entered as a formula. Click OK to begin. OK ? - х High-Low Method Contribution Format Income Statement - Excel PAGE LAYOUT FORMULAS DATA REVIEW VIEW FILE HOME INSERT Sign in Calibri 11 % Paste BIU Alignment Number Cells Editing Conditional Format as Cell Formatting Table Styles Styres Cpboard Font Al v Jay Corporation has decided to prepare contribution income statements for A B с D...

  • Go to pg. 877 lį AA PR 17-3A Equivalent units and related costs; cost of production...

    Go to pg. 877 lį AA PR 17-3A Equivalent units and related costs; cost of production report; entries Obj. 2, 3, 4 White Diamond Flour Company manufactures flour by a series of three processes, beginning with wheat grain being introduced in the Milling Department. From the Milling Department, the materials pass through the Sifting and Packaging departments, emerging as packaged refined flour. EXCEL TEMPLATE The balance in the account Work in Process—Sifting Department was as follows on July 1: Work...

  • Need answers in EXCEL Formula Format (ex: =SUM(B13,B14)  for each yellow highlighted cell IMPORTANT Need answers in...

    Need answers in EXCEL Formula Format (ex: =SUM(B13,B14)  for each yellow highlighted cell IMPORTANT Need answers in EXCEL Formula Format (ex: =SUM(B13,B14)  for each yellow highlighted cell, thank you in advance. Hayword, Inc. uses weighted average costing and has two departments and has provided data related to its mixing department for the month of July. The Controller has asked you prepare a cost reconciliation report and provide the related computations. Use the information included in the Excel Simulation and the Excel functions...

  • Next to each answer, may you please include the equation that was used to find the...

    Next to each answer, may you please include the equation that was used to find the solution. 1. Compute a predetermined overhead rate. 2. Prepare schedules of cost of goods manufactured and cost of goods sold and an income statement. 3. Compute underapplied or overapplied overhead cost and prepare the journal entry to dlose the balance in Manufacturing Overhead to the appropriate accounts. Cost of Goods Manufactured and Cost of Goods Sold - Excel FILE REVIEW HOME INSERT PAGE LAYOUT...

  • Answers must be inputted by a formula Hayword, Inc. uses weighted average costing and has two...

    Answers must be inputted by a formula Hayword, Inc. uses weighted average costing and has two departments and has provided data related to its mixing department for the month of July. The Controller has asked you prepare a cost reconciliation report and provide the related computations. Use the information Included in the Excel Simulation and the Excel functions described below to complete the task • Cell Reference: Allows you to refer to data from another cell in the worksheet. From...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT