Given the projected demands for the next six months, prepare an
aggregate plan that uses inventory, regular time, overtime,
subcontract and backorders. Regular time is limited to 160 units
per month (Cost per Unit = $60 ). Overtime is limited to a maximum
of 20 units per month (Cost per Unit =$90). Units purchased from
the subcontractor (Cost per Unit = $108 ) cannot exceed 50 per
month and the total purchases from the subcontractor over the 6
month period cannot be over 200 units. Backorders cannot exceed 70
units in any given month (Cost per Unit = $5 ) and must be no more
than 10 in Period 6. Average Inventory Holding cost per Unit = $10.
Forecasted Demand as well as Beginning and desired Ending Inventory
are listed in the table below.
Month |
1 |
2 |
3 |
4 |
5 |
6 |
Total |
Regular Output |
|||||||
Overtime Output |
|||||||
Subcontract |
|||||||
Beginning Inventory |
10 |
||||||
Total Available for Sale |
|||||||
Less Forecast |
220 |
200 |
300 |
190 |
150 |
150 |
|
Plus Backlog-Current Period |
|||||||
Less Backlog-Previous Period |
|||||||
Ending Inventory |
10 |
||||||
Average Inventory |
Required:
Find the Minimum Cost Production Plan by Creating a
Spreadsheet in Excel. Use Solver to find the Minimum Cost Solution.
Leave a copy of your Spreadsheet in the DropBox.
Total Cost Month 1 =
Hint: Range (14590 ,14790 )
Total Cost Month 2 =
Hint: Range (13500 ,13610 )
Total Cost Month 3 =
Total Cost Month 4 =
Total Cost Month 5 =
Hint: Range (11510 ,11600 )
Total Cost Month 6 =
Total Cost All Periods =
Hint: Range (81710 ,82710 )
Answer Format: No Dollar ($) signs or commas --- Answers
should be whole numbers.
In: Accounting
(Can you answer my question by explaining, I mean that step by step. I don't want a short answer. Be sure to I like it if you write step by step
For Design and Analysis of the Algorithme lecture)
Peak Finding
Implement the 2-D peak finder mentioned and explain the asymptotic complexity of the algorithm.
In: Computer Science
Types of change
Planned
Emergent
Incremental
Transformationa
Q Critically analyze an explanation of these types and how does it affect on COVID-19 with the application any of these types?
(200-300 )WORDS Minimum
In: Operations Management
Compose a 3-page research paper addressing the role of the Affordable Care Act (ACA) plays in the US health care system. Support your information through research or credible sources. Address the following topics.
In: Nursing
Computech Corporation is expanding rapidly and currently needs to retain all of its earnings; hence, it does not pay dividends. However, investors expect Computech to begin paying dividends, beginning with a dividend of $0.50 coming 3 years from today. The dividend should grow rapidly—at a rate of 35% per year—during Years 4 and 5; but after Year 5, growth should be a constant 7% per year. If the required return on Computech is 13%, what is the value of the stock today?
In: Finance
Excavation Co., a publicly-traded company, has a December 31 year end. For the 2020 fiscal year, there were 100,000 common shares outstanding all year. Net income for the year ended December 31, 2020 was $900,000. The company’s income tax rate is 25%. During 2019, Spade issued a $5,000,000, 5% convertible bond at par. Each $1,000 bond is convertible into 20 common shares. No bonds have been converted as of December 31, 2020. Also during 2019, Spade issued 100,000, $2 cumulative, convertible preferred shares. Two preferred shares are convertible into one common share. The preferred share dividend was declared and paid in June, 2020. Required : Calculate basic and diluted earnings per share for 2020.
In: Accounting
Objective:
In this assignment, you will apply your knowledge and understanding of public goods to the topic of education.
Instruction:
Respond to the following prompts in a post with a minimum of 250 words, then comment on at least TWO other posts. Feel free to bring in additional references to these reply posts. [Please note that you can access the grading rubric by clicking on the top right corner of this post and select 'Show Rubric'.]
In: Economics
A Cascade aerator is used in a groundwater treatment plant to reduce the concentration of methane (CH4) and in the same time to increase the oxygen concentration. The height of each step of the cascade is 0.40 m. The design temperature is 10 0C. The following data is given:
Item
CH4
O2
CW,0
1.50 mg/L
0.70 mg/L
Cg
2 ppb
210000 ppm
kd
0.043
0.039
k (efficiency per step)
27%
25%
Calculate the saturation concentration of CH4 and O2 in water under 1 atmospheric pressure.
What is the required number of cascade steps (n) needed to achieve 91.94% removal of CH4 from water? What is the concentration of CH4 in water in mg/L after aeration in this cascade?
What is the concentration of oxygen in water in mg/L after aeration in this cascade?
What is the length of the Cascade aerator if its capacity is 15 m3/h per 1 m length of the step? The total water flow to be treated is 990 m3/h.
What is the total surface area of the cascade if the width to height ratio of the steps is 1:1?
In: Other
Address the following items for the project to implement change with a new auditing system for CVS Health (https://cvshealth.com)
1. Structure (including alliances, contractual relationships, etc.).
2. Financial data overview: Include a summary of what financial data you examined or would examine. For each financial statement, describe the specific factors that informed you (net revenue, profit loss, balance sheet major).
3.Personnel/Staffing (including provider relationships as appropriate).
4. Implementation schedule: Develop an implementation schedule that identifies the resources and competences in your department and describe how they are matched to the strategic initiative. Identify how your action plan aligns to the organization’s strategic initiatives.
In: Math
The plant asset and accumulated depreciation accounts of Pell
Corporation had the following balances at December 31,
2017:
Plant Asset | Accumulated Depreciation |
|||||
Land | $ | 520,000 | $ | — | ||
Land improvements | 265,000 | 62,000 | ||||
Building | 2,350,000 | 367,000 | ||||
Machinery and equipment | 1,192,000 | 422,000 | ||||
Automobiles | 235,000 | 129,000 | ||||
Transactions during 2018 were as follows:
In: Accounting
Compute the price of a $1,000 par value, 11 percent (semi-annual payment) coupon bond with 22 years remaining until maturity assuming that the bond's yield to maturity is 17 percent? (Round your answer to 2 decimal places and record your answer without dollar sign or commas).
In: Finance
Korean Organizations Management
What do you think were the reasons why Korea’s economy did not develop?
What challenges did Korea face?
How could South Korea overcome these challenges?
What were some of South Korea’s first exports?
In: Operations Management
How (and how much) have human diets changed over the past 100 years? In what ways are daily consumption patterns tied to global concerns and the global marketplace? What factors influence the food people around the world have access to on a daily basis? 200 own words
In: Psychology
Hillyard Company, an office supplies specialty store, prepares its master budget on a quarterly basis. The following data have been assembled to assist in preparing the master budget for the first quarter:
As of December 31 (the end of the prior quarter), the company’s general ledger showed the following account balances:
Cash | $ |
58,000 |
||
Accounts receivable |
214,400 |
|||
Inventory |
60,450 |
|||
Buildings and equipment (net) |
368,000 |
|||
Accounts payable | $ |
90,525 |
||
Common stock |
500,000 |
|||
Retained earnings |
110,325 |
|||
$ |
700,850 |
$ |
700,850 |
|
Actual sales for December and budgeted sales for the next four months are as follows:
December(actual) | $ |
268,000 |
January | $ |
403,000 |
February | $ |
600,000 |
March | $ |
315,000 |
April | $ |
211,000 |
Sales are 20% for cash and 80% on credit. All payments on credit sales are collected in the month following sale. The accounts receivable at December 31 are a result of December credit sales.
The company’s gross margin is 40% of sales. (In other words, cost of goods sold is 60% of sales.)
Monthly expenses are budgeted as follows: salaries and wages, $33,000 per month: advertising, $63,000 per month; shipping, 5% of sales; other expenses, 3% of sales. Depreciation, including depreciation on new assets acquired during the quarter, will be $44,980 for the quarter.
Each month’s ending inventory should equal 25% of the following month’s cost of goods sold.
One-half of a month’s inventory purchases is paid for in the month of purchase; the other half is paid in the following month.
During February, the company will purchase a new copy machine for $2,800 cash. During March, other equipment will be purchased for cash at a cost of $79,000.
During January, the company will declare and pay $45,000 in cash dividends.
Management wants to maintain a minimum cash balance of $30,000. The company has an agreement with a local bank that allows the company to borrow in increments of $1,000 at the beginning of each month. The interest rate on these loans is 1% per month and for simplicity we will assume that interest is not compounded. The company would, as far as it is able, repay the loan plus accumulated interest at the end of the quarter.
Required:
Using the data above, complete the following statements and schedules for the first quarter:
1. Schedule of expected cash collections:
2-a. Merchandise purchases budget:
2-b. Schedule of expected cash disbursements for merchandise purchases:
3. Cash budget:
4. Prepare an absorption costing income statement for the quarter ending March 31.
5. Prepare a balance sheet as of March 31.
mplete the cash budget. (Cash deficiency, repayments and interest should be indicated by a minus sign.)
Requirement 3 |
|
Requirement 4
pare an absorption costing income statement for the quarter ending March 31.
|
Requirement 5:
Prepare a balance sheet as of March 31.
|
NOTE__ some of my numbers already imputted could be wrong.
In: Accounting
How will a hospitality and travel business respond to negative reviews through social media on sites like Yelp! and Trip Advisor? Please choose two negative online reviews of a hospitality or tourism business service that you know well. First, formulate a strategy for responding to a negative review of that business if you believe the comment you have chosen is factually true, but negative. Next, reflect and create a response on a comment if you know the comment is factually incorrect and negative as well. What are the different strategies to responding to comments that are negative about service but in one case you know true and in another false?
In: Operations Management