The following information was extracted from Manuco.'s financial documents.

Assuming that all raw materials are direct materials, calculate the cost of raw materials requisitioned, cost of goods manufactured, and cost of goods sold based on the provided information.

Required

Do not enter dollar signs or commas in the input boxes.

Round your answers to the nearest whole number.

Cost of raw materials requisitioned: $ Answer

Cost of goods manufactured: $ Answer

Cost of goods sold: $ Answer

Jump to...                   Jump to...                   Tutorial: Introduction                   Introduction                   News forum                   Guidelines for Assessments & Exams (for Students)                   Rounding Rules for Online Questions                   Templates Zipped File (Excel)                   Templates Zipped File (Word)                   Digital Textbook                   E-Book Student Guide                   Workbook Student Edition (PDF)                   Correction Notice to Students                   Tutorial: Introduction to Managerial Accounting                   Tutorial: Planning and Controlling                   Tutorial: Cost of Goods Manufactured                   Tutorial: Introduction to Cost Accounting                   Chapter 1 Quiz                   Chapter 1 Post-Class Homework                   Chapter 1 - An Overview of Managerial Accounting                   Chapter 1 - Workbook Exercises                   Chapter 1 - Workbook Solutions                   Tutorial: Introduction to Job Order Costing                   Tutorial: Manufacturing Overhead                   Tutorial: Overhead and Job Order Costing                   Chapter 2 Quiz                   Chapter 2 Post-Class Homework                   Chapter 2 - Job Order Costing                   Chapter 2 - Workbook Exercises                   Chapter 2 - Workbook Solutions                   Tutorial: Just-in-Time and Quality Management                   Chapter 4 Quiz                   Chapter 4 Post-Class Homework                   Chapter 4 - Cost Management Strategies                   Chapter 4 - Workbook Exercises                   Chapter 4 - Workbook Solutions                   Tutorial: Cost Behavior                   Tutorial: Break Even Analysis                   Tutorial: Differential and Sensitivity Analyses                   Tutorial: Operating Leverage                   Chapter 5 Quiz                   Chapter 5 Post-Class Homework                   Chapter 5 - Cost-Volume-Profit Analysis                   Chapter 5 - Workbook Exercises                   Chapter 5 - Workbook Solutions                   Tutorial: Introduction to Budgeting                   Tutorial: Operating Budget I                   Tutorial: Operating Budget II                   Tutorial: Cash Budget                   Chapter 7 Quiz                   Chapter 7 Post-Class Homework                   Chapter 7 - Master Budget                   Chapter 7 - Workbook Exercises                   Chapter 7 - Workbook Solutions                   Tutorial: Relevant and Irrelevant Costs                   Tutorial: Keep or Drop                   Tutorial: Make or Buy                   Tutorial: Product Mix                   Tutorial: Retain or Replace and Sell or Process                   Chapter 11 Quiz                   Chapter 11 Post-Class Homework                   Chapter 11 - Relevant Cost and Decision-Making                   Chapter 11 - Workbook Exercises                   Chapter 11 - Workbook Solutions      

Question 11

Which formula below successfully performs an operation on a range of values stored in Excel cells?

=SQRT( A1:A15)

= EXP( A1:A15)

=LOG(A1:A15)

=ABS(A1:A15)

=SUM(A1:A15)

Question 12

Cells A1 through A10 contain the values shown in the table below. What does this formula evaluate to?
= SUM(A1:A10) - MAX( A1:A5 )

0

29

30

36

nothing - there is a syntax error in one of the formulas

Question 13

Which of the following formulas contains a syntax error?

Group of answer choices

= MAX( A1:A10, A15)

= SUM( A1:B10)

= AVERAGE( A1:A10:-B2)

= MIN( A1, B2, C3)

none of the above

Question 14

What is displayed if you select one data series in a worksheet and then create an x-y scatter chart?

uses data series as x coordinates and integers as y coordinates

uses the data series as y coordinates and integers as x coordinates

uses the data series as both x coordinates and as y coordinates

produces a blank chart

displays an error message but no chart

Question 15

What will be displayed if you select two data series in a worksheet and then choose to create a scatter chart?

Group of answer choices

uses the first data series as y coordinates and second data series as x coordinates

uses the first data series as x coordinates and second data series as y coordinates

uses each data series for y coordinates of separate lines and integers for x coordinates

uses each data series for x coordinates of separate lines and integers for y coordinates

none of the above

Question 16

When you copy a formula, such as = A1 + B2, to another cell, the cell references A1 and B2 will change. Why does a spreadsheet program do this?

to complicate the life of the user

so that the formula will still use the same numbers in its calculations

to allow the same formula to be used with other values in other cells

to show that the inverse of the square root of the radical computation is still valid

Question 17

The main strength of a spreadsheet program is that it allows the presentation of data and charts based on that data in a way that can be explained to and manipulated by the user.

True

False

Question 18

If the two data series used for an x-y scatter chart have different amounts of values in them, a spreadsheet program will treat this as an error and not produce a chart.

True

False

Question 19

If you copy a table of numbers from a web page and paste them into a worksheet, each value will be pasted into its own cell and the number of rows and columns will be preserved.

Here is a webpage (Links to an external site.) with a table on it that you can use to test this out.

True

False

Question 20

If you copy and paste a range from a worksheet into a word processor document, a table is created with one value per cell and the same number of rows and columns.

Group of answer choices

True

False

Case Analysis 3: You are the General Manager at the Bicker, Slaughter, and Lynch Law Firm. There is an opportunity to buy out a small law firm that was just started by a young MBA/JD, and you believe the firm can be grown and become a lucrative part of your Firm. With help from your finance leader, you have estimated the following benefit streams for this new division:

Before Tax Cash Flow From Operations

Year 1 $(149,000)

Year 2 $0

Year 3 $51,380

Year 4 $88,760

Year 5 $114,100

Year 6 $129,780

Year 7 $143,640

Year 8 $167,300

After Tax Net Income From Operations

Year 1 $(103,500)

Year 2 $(50,500)

Year 3 $36,700

Year 4 $63,400

Year 5 $81,500

Year 6 $92,700

Year 7 $102,600

Year 8 $119,500

After Tax Cash Flow From Operations

Year 1 $(85,600)

Year 2 $15,000

Year 3 $48,600

Year 4 $72,200

Year 5 $95,550

Year 6 $101,300

Year 7 $125,200

Year 8 $140,200

You estimate that the purchase price for this firm would be $200,000 and that additional net working capital would be needed in the amount of $60,000 in year 0, an additional $15,000 in year 2 and then $15,000 in year 5.

• BSL usually spend about $275,000 per year in advertising. If you make this acquisition, you would ask that advertising spending be increased by an incremental one-time amount of $45,000 in year 0 to publicize the firm’s expansion.

• Your finance leader has indicated that the firm has access to a credit line and could borrow the funds at a rate of 6%. He also mentions that when he runs project economics for capital budgeting (such as a new copier or a company car), he recommends a standard 10% rate discount, but the one other time they looked at an acquisition of a smaller firm, he used a 13% rate discount. Obviously you will want to select the most appropriate discount rate for this type of project.

• At the end of 8 years, the plan is to sell this division. The estimated terminal value (the sale and the return of working capital) is conservatively estimated to be $350,000 of after-tax cash flow help.

Using the data that you need (and ignoring the extraneous information), for this potential acquisition, calculate each of the following items: the Nominal Payback, the Discounted Payback, the Net Present Value, the IRR.

In an MS Word document, in paragraph form, respond to the following questions:

1) From a purely financial (numbers) perspective, would you recommend this purchase to management? Why?

2) What are some of the non-financial elements that need to be considered for this proposal?

3) Assumptions in project economics can have a huge impact on the result. Identify 3 financial elements/assumptions in your analysis that would make this project financially unattractive? In other words, what would have to be true for this to be a bad investment?

4) If you were the CEO, would you approve this proposal? Why or why not?

Jessica is a 30 year old immigrant from Mexico City. She and her husband Marco have been in the U.S for the last three years and have finally earned enough money to move out of their aunt home and into an apartment of their own. They are both hard workers. Jessica works 50 hours a week at a local restaurant, and Marco has been contracting side jobs in construction. Six months before their move to an apartment, Jessica finds out she is pregnant. Four months later, Jesssica and Marco arrive at the county hospital, a large, public, nonteaching hospital. A preliminary ultrsaound indicates a pssible abnormality with the fetus. Further scans are conducted and it determind that the fetus has a rare condition in which it has not developed any arms, and will not likely develop them. There is also a 25% chance that the fetus may have down syndrome. Dr. Wilson, the primary attending physician is seeing Jessica for the first time, since she and Marco did not receive earlier prenatal care over concerns about finances. Marco insists that Dr. Wilson refrain from telling Jessica the scan results, assuring him that he will tell his wife himself when she is emotionally ready for the news. While Marco and Dr. Wilson are talking in another room, Aunt Maria walks into the room with adistressed look on her face. She can tell that something is wrong and inquires of Dr. Wilson. After hearing of the diagnosis, she walks out of the room wailing loudly and praying out loud. Marco and Dr. Wilson continues their discussion and Dr. Wilson insists that he has an obligation to Jessica his patient and that she has a right to know the diagnosis of the fetus. He furthermore is intent to discussing all relevant factors and options regrading the next step, including abortion. Marco insists on taking some time to think of how to break the news to Jessica, but Dr. Wilson, frustrated with the direction of the conversation, informs husband that such a choice is not his to make. Dr. Wilson proceeds back across the hall, where he walks in on Aunt Maria awkwardly praying with Jessica and phoning the priest. At that point, Dr. Wilson gently but briefly informs Jessica of the diagnosis, and lays out the option for abortion as a responsible medical alternative, given the quality of life such a child would have. Jessica looks at him and struggles to hold back hers tears. Jessica is torn between her hopes of a better socioeconomic position and increased independence, along with her conviction that all life is sacred. Marco will support Jessica in whatever decision she makes, but is finding it difficult to not view the pregnancy and prospects of a disabled child as aburden and a barrier to their economic security and plans. Dr. Wilson lays out all of the options but clearly makes his view known that abortion is "scientifically" and medically a wise choice is this situation. Aunt Maria pleads with Jessica to follow through with the pregnancy and allow what "God intends" to take place, and urges Jessica to think of her responsibility as a mother. Write a 500-750 word analysis of this situation be sure to address the following questions.

1. Which theory or theories are being used by Jessica, Marco, Maria and Dr. Wilson to determine the moral status of the fetus? Explain?

Jessica is a 30 year old immigrant from Mexico City. She and her husband Marco have been in the U.S for the last three years and have finally earned enough money to move out of their aunt home and into an apartment of their own. They are both hard workers. Jessica works 50 hours a week at a local restaurant, and Marco has been contracting side jobs in construction. Six months before their move to an apartment, Jessica finds out she is pregnant. Four months later, Jesssica and Marco arrive at the county hospital, a large, public, nonteaching hospital. A preliminary ultrsaound indicates a pssible abnormality with the fetus. Further scans are conducted and it determind that the fetus has a rare condition in which it has not developed any arms, and will not likely develop them. There is also a 25% chance that the fetus may have down syndrome. Dr. Wilson, the primary attending physician is seeing Jessica for the first time, since she and Marco did not receive earlier prenatal care over concerns about finances. Marco insists that Dr. Wilson refrain from telling Jessica the scan results, assuring him that he will tell his wife himself when she is emotionally ready for the news. While Marco and Dr. Wilson are talking in another room, Aunt Maria walks into the room with adistressed look on her face. She can tell that something is wrong and inquires of Dr. Wilson. After hearing of the diagnosis, she walks out of the room wailing loudly and praying out loud. Marco and Dr. Wilson continues their discussion and Dr. Wilson insists that he has an obligation to Jessica his patient and that she has a right to know the diagnosis of the fetus. He furthermore is intent to discussing all relevant factors and options regrading the next step, including abortion. Marco insists on taking some time to think of how to break the news to Jessica, but Dr. Wilson, frustrated with the direction of the conversation, informs husband that such a choice is not his to make. Dr. Wilson proceeds back across the hall, where he walks in on Aunt Maria awkwardly praying with Jessica and phoning the priest. At that point, Dr. Wilson gently but briefly informs Jessica of the diagnosis, and lays out the option for abortion as a responsible medical alternative, given the quality of life such a child would have. Jessica looks at him and struggles to hold back hers tears. Jessica is torn between her hopes of a better socioeconomic position and increased independence, along with her conviction that all life is sacred. Marco will support Jessica in whatever decision she makes, but is finding it difficult to not view the pregnancy and prospects of a disabled child as aburden and a barrier to their economic security and plans. Dr. Wilson lays out all of the options but clearly makes his view known that abortion is "scientifically" and medically a wise choice is this situation. Aunt Maria pleads with Jessica to follow through with the pregnancy and allow what "God intends" to take place, and urges Jessica to think of her responsibility as a mother. Write a 500-750 word analysis of this situation be sure to address the following questions.

2. How does the theory determine or influence each of their recommendation for action? What theory do you agree with?

Task

Create an outline (plan to write your message – sample outline provided below) and an email message based on case details identified below.

Situation

You work as an assistant office manager for Diamond Clear, a family-run window installation company and a scheduling issue has arisen in the office. You are writing on behalf of Lucia to her brother Scott regarding the situation (includes the problem) and your request (main idea).

In your email message you will inform Scott that there is a shipment delay. The message should explain that Lucia thinks that Scott should hold off on the corporate job and start the Herbert Street job instead. The message should also tell Scott to confirm that he understands the situation and get back to you right away if he has any concerns about Lucia's plan.

Facts

Include as many facts below as necessary to create an effective message. Diamond Clear is a family business, run by siblings Scott and Lucia Diamond. The company was started over 30 years ago by Scott and Lucia's father, who built his business slowly by honoring the customer and being true to his word.

• Scott is in charge of the company's operational matters. Scott typically spends his days visiting the various installation sites, keeping track of deliveries, and making sure that jobs run smoothly and finish on time.

• Lucia runs the financial end of the company. She typically spends her days in the office taking care of such things as financing, bookkeeping, ordering, and scheduling.

• The siblings take turns making estimates for prospective clients. Lucia takes care of most of the large business clients. Scott usually deals with individual homeowner accounts.

• This week, Diamond Clear has two jobs scheduled. The first job is scheduled to start tomorrow, Tuesday, for a family on Herbert Street. It is likely to take 1 to 2 days to complete. The customer is having a wedding on the weekend, and so the job absolutely needs to be done before then.

• The second job is a corporate account that is scheduled to start today (Monday) and is likely to take 2 to 3 weeks.

• Lucia has just learned this morning that the window shipment she was expecting for the corporate job has been delayed. Lucia tried to tell Scott about the delay,but could not get through to him. Lucia then went off to a downtown business meeting and will probably be out of communication until late this afternoon.

• The delay means that Diamond Clear currently has only enough materials to begin one of the two jobs that are scheduled for the week.

• Diamond Clear's window supplier is quite reliable, and Lucia is fairly confident that the new window shipment will arrive tomorrow. However, there have been a few occasions in the past when shipments were delayed by more than one day.

• Before she left for her meeting, Lucia told you that she thinks the Herbert Street job should be the priority in this situation. Lucia thinks Scott should change the order of the two jobs and start the Herbert Street job first rather than the corporate job.

Assignment Direction:

1. Complete Part I of this assignment first, if you have not done so, because it provides guided practice on questions similar to the questions in Part II here.
2. Check out the “Important Resources and Assignment Guides” in the Modules section on Canvas to see how to properly show your math work. There are also examples of the APA-style tables and graphs (figures) for your reference.
3. Your submitted assignment must be in Word format, with a clear answer typed out for each question, even if you show math work in a separate Excel file.

Q1) One-Sample t-Test (21 points total)

I am curious about how many hours per week my students spend on their online coursework. So, I surveyed 9 of my students on how many hours per week they spend on my online PSY 230 course. According to a survey of online college students (in all courses), students studied an average of 9 hours a week for a 3-credit course. I assume that the national study time scores are normally distributed, and I set the significance level at α = .05.

1. What is the dependent variable in this hypothesis test? What is the “sample” for this one-sample t test? (2 points total: 1 for each question)

2. I am interested in testing whether there are any differences between my students and the national average, so my hypothesis is non-directional. What would be the null and alternative hypotheses in both words and symbol notations for my analysis? (4 points total: 1 for each hypothesis in words, 1 for each hypothesis in notation)

3. Calculate the sample mean. (2 points total: 1 for work, 1 for answer)

4. Estimate the standard deviation of the population (2 points total: 1 for work, 1 for answer)

5. Calculate the standard error (standard deviation of the sampling distribution) (2 points total: 1 for work, 1 for answer)

6. Calculate the t statistic for the sample (2 points total: 1 for work, 1 for answer)

7. Specify whether the test is a one-tailed or two-tailed test based on the hypotheses form (b), and then determine the critical t value(s) based on the type of test and the preset alpha level (2 points total: 1 for each answer)

8. Compare the t statistic with the critical t value. Is the calculated t statistic more extreme or less extreme than the critical t value? Then make a decision by stating whether we “reject” or “fail to reject” the null hypothesis (2 points total: 1 for each answer)

1. Interpret the result in 1-2 sentences (you may restate the hypothesis accepted or explain it in your own words) (1 point)

10. Calculate the raw effect size and the standardized effect size of this hypothesis test (4 points total: 2 per effect size: 1 for work, 1 for answer)

1.

(i) Demand function for tickets for a rock concert has been estimated to be

ln Q = 3.737 - 1.518 ln P +1.213 ln I

where Q denotes number of tickets (in thousands), P the (average) ticket price and I the

average income of the concert goers.

Determine the values of the price elasticity of demand and the income elasticity of

Demand.

(ii) In a recent study it has been estimated that the own price elasticity of demand for a

Special type of U.S. manufactured automobile tires is - .75, while the income elasticity of

Demand is 1.1 and the cross price elasticity of demand with respect to foreign imports is

1.4. The current sales volume for the U.S. manufactured tires is 5 million units per year.

It is anticipated that the price of the foreign imports will rise by 5%.

(a) Assuming that average income of the target group of customers will not change,

Calculate the number of tires that the tire manufacturers will be able to sell if they plan to increase their own price by 3%.

(b) According to newly released economic data It is now expected that over the next year the average income of the target group of consumers in the U.S. will grow by 4%.

Calculate the amount (%) by which the U.S. tire manufacturers can adjust their price if

they wish to increase their sales volume by 8.4% over the initial 5 million units. Assume

the same increase in foreign tire prices as above.

(iii) Bright Future, Ltd (BF) is a nonprofit foundation providing medical treatment to

emotionally distressed children. BF has hired you as a business consultant to design an

employment policy that would be consistent with its goal of providing the maximum

possible service given its limited financial resources. You have determined that the

service (Z) provided by BF is a function of its medical staff input (M) and social worker

staff input (S) which is given by:

Z = M + .5S + .5 MS - S2

BF’s staff budget for the coming year is $1,200,000. Annual employment costs are

$30,000 for each social worker staff member (S) and $60,000 for each medical staff

member (M).

(a) Using the Lagrangean multiplier approach calculate the optimal (i.e., service

maximizing) combination of medical and social worker staff. Determine the

optimal amount of service provided by BF.

(b) Calculate BF’s marginal cost. Explain your answer.

(c) Using Excel-Solver verify your answer to (a).

(Show your work. Show the spreadsheets in detail. Show the Solver window

embedded on the relevant worksheet so that the commands in the Solver

window become directly visible and are linked to the cells of the worksheet. To

show the solver window, use print screen command on your key board and

then create a MS Word document using paste. See The Solver supplement for

help.)

(iv) In year 2016 price of a (750 ml.) bottle of wine sold by Richard Mondavi was $20.00. Fifty

(thousand) bottles were sold. It was estimated that the own price elasticity of demand for wine

of that type was -1.6. Assuming a straight line demand curve, determine the demand equation

for Mondavi's wine.

Show and explain all your calculations.

There are 3 questions. You must show your work and how you got the answer. PLEASE DO NOT ANSWER IF YOU ARE NOT SURE

You have been asked to look at production options for the Android01, since production methods and allocation of costs have implications for cost per unit. Two alternative methods of production are being considered. Begin by gathering data (using financial information in decision making), then determine the suitability of the project.

The production of Android01 will share some production facilities and service divisions with Processor01. Fixed costs are $5 million per year, and will be assigned at the rate of 30 percent to Android01 and 70 percent to Processor01.

The variable cost of the production facilities and service divisions is $25 million per year. The square footage of factory space and labor needed for the production of 500 units of Processor01 and 300 units of Android01 are listed below.

The remaining cost for the production of Android01 is for components, at $25,000 per unit.

Question 1: In Method B, what would be the cost per unit of producing Android01 using factory space as the allocation basis? What would be the cost per unit using labor as the allocation basis?

Before starting on your calculations, review materials on production cost allocation.

An alternate method of assigning costs is activity-based costing.The major activities for the production of both Processor01 and Android01 are fabricator setup and component assembly. There are 500 units of Processor01 and 300 units of Android01 produced every year. There will be a total of 25,000 setups per year for at a total cost of $10 million. Each unit of Android01 will require 40 setups. There will be a total of 125,000 assemblies per year at a total cost of $15 million. Each unit of Android01 will require 180 assemblies. The remaining cost for the production of Android01 is for components, at $25,000 per unit.

Question 2: What would be the cost per unit of producing Android01 using activity-based costing?

Note that in addition to the setup costs and assemblies costs there are two more costs to add: (1) fixed costs of $5 million, which are still distributed at a rate of 30 percent to Android01 and 70 percent to Processor01, and (2) the cost of Android01 components at $25,000 per unit.

Discuss the differences in the cost per unit of Android01 using space as an allocation basis, using labor as an allocation basis, and using activity-based costing. Which method do you think is the most accurate way to assign costs?

Next, suppose IPS uses markup pricing for Android01. Fixed costs are $4.5 million, and for a level of production of 300 units, the variable cost per unit is $48,000.

Question 3: What is the price of the Android01 at 30 percent markup over full cost?

Submit your Markup Pricing Report and Calculations to the dropbox below. Submit a spreadsheet showing your calculations in Excel and provide a narrative analysis in Word. Your narrative analysis should summarize the results of your analysis and make recommendations for the benefit of company.