(Use an excel sheet to show formulas used) 3. A producer of pottery is considering the addition of a new plant to absorb the backlog of demand thatnow exists. The primary location being considered will have fixed costs of $9,200 per month and vanable costs of 70 cents per unit produced. Each item is sold to retailers at a price that averages 90 centS.a. What volume per month is required in order to break even?b. What profit would be realized on a monthly volume of 61,000 units? 87,000 units?c. What volume is needed to obtain a profit of $16,000 per month?d. What volume is needed to provide a revenue of $23,000 per month?

(a) Volume break even= Fixed cost/(revenue per unit- variable cost per unit) (b) Profit=…

Answered: (Use an excel sheet to show formulas…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Finance Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Do not provide Excel Screet shot rather use tool table Answer completely.
Part (a). You are working as an accountant in XYZ Limited (a mid-size accounting firm with a reasonable range of clients). Currently, you ask the employees to provide the relevant information to initiate the planning phase of the audit. Further, you plan to draw the data from analytical reviews and substantive testing from the operational database. However, the management of your client wants you to draw the data from the data warehouse. The management argues that the data extracted from the operational database will disrupt the operations. Further, the management points out that operational data are copied weekly into the data warehouse, and all data you need are contained there. Required: We have discussed the operational database and data warehouse under the topic "ERP Core Applications" in the Week 10 Interactive Tutorial. Based on this discussion, outline your response to the management's proposal and mention any concerns you might have. Part (b). Production planning and…
Please do not give solution in image format thanku
G
Please do not give solution in image format thanku The Muppet Company makes Monster Cookies in several large commercial bakeries across the United States. The process is the same in all the bakeries and consists of mixing the cookie dough, forming the cookies (called base cakes), baking and cooling them. The cooled cookies are then iced and packaged. The packaged cookies are then shipped hourly to a company warehouse. As part of a continuous improvement program, Henson Sullivan, the operations manager in one of these bakeries, wondered if the production process could be improved. To understand the process, she took a pencil and clipboard and drew a value stream map of the cookie process. Henson knew that the monthly production requirement was 12,000 cases. The bakery operated 20 days per month with one 8-hour shift per day with two 30 minute lunch break. Since the line is dedicated to Monster cookies, there is no changeover time or set up time and the current batch size equals one.…
Which of these factors would NOT be needed when prorating an expense? the total of the annual bill the real estate transfer tax amount whether the expense was prepaid or accrued the length of the calendar being used
Which are the 3 payroll options available inside QuickBooks Online companies?(Select all that apply) A. QuickBooks Online Do-it-Yourself Payroll B. QuickBooks Online Core Payroll C. QuickBooks Online Premium Payroll D. QuickBooks Online Elite Payroll E. QuickBooks Online Self-Service Payroll
Please do not give solution in image format thanku
I need typing clear urjent no chatgpt use i will give 5 upvotes full explanation pls
Please do not give solution in image format thanku Pick three important roles you play in your life (for example, student, parent, intern, the role you play at your job, etc.). What are your top priorities for each role regarding the impact you want to make? Identify which quadrant in the Time Management Matrix they fit into.
The formula to determine tax payable is: a) Income before income tax expense (From the income tax return) multiplied by the income tax rate. b) Income before income tax expense (From the income tax statement) multiplied by the income tax rate. c) Taxable income (from the income tax return) multiplied by the income tax rate. d) Taxable income (from the income statement) multiplied by the income tax rate.
Please solve it down Thanks in advance

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS