In this portion of an excel spreadsheet the user has

This preview shows page 11 - 14 out of 18 pages.

We have textbook solutions for you!
The document you are viewing contains questions related to this textbook.
Accounting Information Systems
The document you are viewing contains questions related to this textbook.
Chapter 5 / Exercise P5-5
Accounting Information Systems
Dull/Gelinas
Expert Verified
8.In this portion of an Excel spreadsheet, the user has given values for selling price, the costs, and a sample volume. Give the cell formula fora.cell E12, break-even volume.b.cell E16, total revenue.c.cell E17, total cost.d.cell E19, profit/loss.ABCDE1234Break-even calculation56Selling price per unit1078Costs9Fix cost840010Variable cost per unit4.51112Break-even volume1314Sample
We have textbook solutions for you!
The document you are viewing contains questions related to this textbook.
Accounting Information Systems
The document you are viewing contains questions related to this textbook.
Chapter 5 / Exercise P5-5
Accounting Information Systems
Dull/Gelinas
Expert Verified
calculation15Volume200016Total revenue17Total cost1819Profit lossANS:
PTS:1TOP:Spreadsheets for management science9.A furniture store has set aside 800 square feet to display its sofas and chairs. Each sofa utilizes 50 sq. ft. and each chair utilizes 30 sq. ft. At least five sofasand at least five chairs are to be displayed.a.Write a mathematical model representing thestore's constraints.b.Suppose the profit on sofas is $200 and on chairs is $100. On a given day, the probability that a displayed sofa will be sold is .03 and that a displayed chair will be sold is .05. Mathematically model each of the following objectives:1.Maximize the total pieces of furniture displayed.2.Maximize the total expected number of daily sales.3.Maximize the total expected daily profit.ANS:a.50s + 30c 800s 5
5
PTS:1TOP:Model development10.A manufacturer makes two products, doors and windows. Each must be processed through two work areas. Work area #1 has 60 hours of available production time. Work area #2 has 48 hours of available production time. Manufacturing of a door requires 4 hours in work area #1 and 2 hours in workarea #2. Manufacturing of a window requires 2 hours in work area #1 and 4 hours in work area #2. Profit is $8 per door and $6 per window.a.Define decision variables that will tell how many units to build (doors and windows).b.Develop an objective function that will maximize profits.c.Develop production constraints for work area #1 and #2.ANS:
PTS:1TOP:Model development11.A small firm builds television antennas. The investment in plan and equipment is $200,000. The variable cost per television antenna is $500. The price of the television antenna is $1000. How many television antennas would be needed for the firm to break even?
PTS:1TOP:Breakeven analysis

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture