On the Purchase Plan sheet, write the formulas that will populate the retail price, unit cost,...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
On the Purchase Plan sheet, write the formulas that will populate the retail price, unit cost, and storag cost per unit in their respective cells. Write the formulas that calculate the gross revenue (number purchased multiplied by the retail price), the total unit cost (unit cost multiplied by the number purchased), the total storage cost (storage cost per unit multiplied by the number purchased), the total cost (total unit cost plus total storage cost), and the profit (gross revenue minus the total cost) for each of the toys. Write the formulas to add the total number of toys purchased in cell B8, the total cost in cell 18, and the total profit in cell J8. Check that formulas entered in Step 4 link the objective cell (total profit) with the variable cells. Add sample values to the variable cells to ensure that your worksheet is set up correctly and produces the expected results. Create a constraints list in the worksheet that identifies the constraints in this problem. Format all monetary fields as Accounting with two decimal places. Use Solver to determine the best way to purchase the Mighty Toys sets and kits and maximize the profit. Produce an answer report of your final solution. Use the answer report to recommend additional changes that might maximize the total profit. Place your recommendations in a cell on the answer report worksheet. Save and close the MightyToys.xlsx workbook. On the Purchase Plan sheet, write the formulas that will populate the retail price, unit cost, and storag cost per unit in their respective cells. Write the formulas that calculate the gross revenue (number purchased multiplied by the retail price), the total unit cost (unit cost multiplied by the number purchased), the total storage cost (storage cost per unit multiplied by the number purchased), the total cost (total unit cost plus total storage cost), and the profit (gross revenue minus the total cost) for each of the toys. Write the formulas to add the total number of toys purchased in cell B8, the total cost in cell 18, and the total profit in cell J8. Check that formulas entered in Step 4 link the objective cell (total profit) with the variable cells. Add sample values to the variable cells to ensure that your worksheet is set up correctly and produces the expected results. Create a constraints list in the worksheet that identifies the constraints in this problem. Format all monetary fields as Accounting with two decimal places. Use Solver to determine the best way to purchase the Mighty Toys sets and kits and maximize the profit. Produce an answer report of your final solution. Use the answer report to recommend additional changes that might maximize the total profit. Place your recommendations in a cell on the answer report worksheet. Save and close the MightyToys.xlsx workbook.
Expert Answer:
Related Book For
Horngrens Accounting
ISBN: 978-0134674681
12th edition
Authors: Tracie L. Miller nobles, Brenda L. Mattison, Ella Mae Matsumura
Posted Date:
Students also viewed these finance questions
-
Attorney Carey talks about the current controversy concerning proposed Right Whale regulations impacting the lobster industry in Maine. This is a classic example of where those negatively impacted by...
-
Consider the following four 16b words: 0x3dcc Ox156f 0x8852 0x4c8e What is the checksum that results from adding the four words together? Remember to complement the final result. Blackboard expects a...
-
CANMNMM January of this year. (a) Each item will be held in a record. Describe all the data structures that must refer to these records to implement the required functionality. Describe all the...
-
A process is controlled with a fraction nonconforming control chart with three-sigma limits, n = 100, UCL = 0.161, center line = 0.080, and LCL = 0. (a) Find the equivalent control chart for the...
-
A grating has 600 rulings / mm and is 5.0 mm wide. (a) What is the smallest wavelength interval it can resolve in the third order at = 500 nm? (b) How many higher orders of maxima can be seen?
-
Ethylene gas ( $\mathrm{MW}=28, k=1.3, \mu=0.1 \mathrm{cP}$ ) at $100^{\circ} \mathrm{F}$ is fed to a reaction vessel from a compressor through $100 \mathrm{ft}$ of $2 \mathrm{in}$. sch 40 pipe...
-
On December 10, 2017, Robin Franchises, a U.S. company, received a purchase order from a U.K. customer for delivery of merchandise on January 15, 2018. The price of the merchandise is 8,000,000,...
-
The following are a series of unrelated situations. 1. Halen Companys unadjusted trial balance at December 31, 2014, included the following accounts. Halen Company estimates its bad debt expense to...
-
Required information [The following information applies to the questions displayed below.] Bergo Bay's accounting system generated the following account balances on December 31. The company's manager...
-
Real option analysis can be used to alter the timing, scale, or other aspects of an investment in response to market conditions. Businesses face the dilemma of whether to invest in a project or...
-
Answer the following question based on the scenario in Learning Activity 5. What is the ordinary business income (loss) from Form 1065? a) $69,327 b) $22,555 c) $32,032 d) $54,587 Answer the...
-
January 15Assign Job 76 to Cold Refrigeration for the purchase of a refrigeration system.The start date will be January 16. The completion date will be no later than February 28. The estimated direct...
-
After discovering that you are studying communications, a friend asks for your help. Your friend feels that he is often misled by content viewed on the internet and information received through...
-
determining the value using the discounted cash flow method. I also need help identifying the free cash flow and the weighted average cost of capital. Account Description/Year 2021 2022 2023 2024...
-
Trying to figure out the cost benefit analysis for Kerdall Paper Co. Cost-Benefit Analysis Benefit/Savings 25% likely 50% likely 75% likely Present Value (at 20%) of Possible Litigation Cost to...
-
A building supply company is manufacturing residential doors. Because demand has been increasing for their products, the company is trying to evaluate whether to add a second production line. For...
-
Barca Company's B/S at the end of 2019 included the following items: Current assets $1,326,000 Current liabilities Land 36,000 Bonds payable $1,224,000 1,320,000 Building 1,344,000 Common shares...
-
Write a paper about how diet relates to breast cancer in women study design to use: case control study purpose & rationale the purpose of this final project is to utilize the methods and...
-
Taking the closing balance sheet from the example above prepare a balance sheet and profit and loss account for the third year of trading incorporating the following transactions: 1. The owner...
-
Sid's business during the next month is even better than in the first. Sid purchased a further 200 of diesel and had just filled his tank with 35 worth before finishing on the last day of the month....
-
Prepare a cash flow statement for the above business as at the end of year 2 to create the comparative figures for the above statement
Study smarter with the SolutionInn App