Questions
Given the projected demands for the next six months, prepare an aggregate plan that uses inventory,...

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...

(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...

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...

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.

  • What are the primary goals of ACA?
  • What are the current benefits and issues pertaining to the ACA?
  • What is a pre-existing medical condition under the ACA?
  • What is the ACA Marketplace?
  • What are the Federal government Medicaid Expansion funds?

In: Nursing

Computech Corporation is expanding rapidly and currently needs to retain all of its earnings; hence, it...

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,...

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...

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'.]

  • Is education a public good? Does education have external benefits? If so, what are some of those public benefits? In your opinion are the external benefits large or small? Why? What should government do to promote the efficient provision of products that have external benefits? If you think that government should put more resources into education, what might be some of the opportunity costs of that decision? How would an economist determine the right amount of government support for education?

In: Economics

A Cascade aerator is used in a groundwater treatment plant to reduce the concentration of methane...

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...

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...

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:

  1. On January 2, 2018, machinery and equipment were purchased at a total invoice cost of $345,000, which included a $7,200 charge for freight. Installation costs of $44,000 were incurred.
  2. On March 31, 2018, a small storage building was donated to the company. The person donating the building originally purchased it three years ago for $36,000. The fair value of the building on the day of the donation was $23,000.
  3. On May 1, 2018, expenditures of $67,000 were made to repave parking lots at Pell’s plant location. The work was necessitated by damage caused by severe winter weather.
  4. On November 1, 2018, Pell acquired a tract of land with an existing building in exchange for 10,000 shares of Pell's common stock that had a market price of $39 per share. Pell paid legal fees and title insurance totaling $40,000. Shortly after acquisition, the building was razed at a cost of $52,000 in anticipation of new building construction in 2019.
  5. On December 31, 2018, Pell purchased a small storage building by giving $16,950 cash and an old automobile purchased for $26,500 in 2014. Depreciation on the old automobile recorded through December 31, 2018, totaled $15,200. The fair value of the old automobile was $5,450.

In: Accounting

Compute the price of a $1,000 par value, 11 percent (semi-annual payment) coupon bond with 22...

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?...

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...

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...

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:

  1. 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

  1. 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

  1. 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.

  2. The company’s gross margin is 40% of sales. (In other words, cost of goods sold is 60% of sales.)

  3. 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.

  4. Each month’s ending inventory should equal 25% of the following month’s cost of goods sold.

  5. 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.

  6. 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.

  7. During January, the company will declare and pay $45,000 in cash dividends.

  8. 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
Hillyard Company
Cash Budget
January February March Quarter
Beginning cash balance $58,000 $30,560 $31,860
Add cash collections 295,000 442,400 543,000 1,280,400
Total cash available 353,000 472,960 574,860 1,280,400
Less cash disbursements:
Inventory purchases 226,200 (294,300) (245,325) (765,825)
Selling and administrative expenses 128,240 (33,000)
Equipment purchases (79,000) (79,000)
Cash dividends 45,000 (9,450)
Total cash disbursements 399,440 (294,300) (366,775) (844,825)
Excess (deficiency) of cash (46,440) 178,660 208,085 435,575
Financing:
Borrowings 77,000 (79,000)
Repayments (31,860)
Interest (79,310)
Total financing 77,000 (158,310) 0
Ending cash balance $30,560 $178,660 $49,775 $435,575

Requirement 4

pare an absorption costing income statement for the quarter ending March 31.

Hillyard Company
Income Statement
For the Quarter Ended March 31
Sales
Cost of goods sold:
Beginning inventory
Purchases
Ending inventory 0
Goods available for sale 0
Gross margin 0
Selling and administrative expenses:
Salaries and wages 33,000
Advertising 63,000
Shipping
Depreciation
Other expenses
96,000
Net operating income (96,000)
Interest expense
Net income $(96,000

Requirement 5:

Prepare a balance sheet as of March 31.

Hillyard Company
Balance Sheet
March 31
Assets
Current assets:
Cash $790,800
Accounts receivable
Inventory
Total current assets 790,800
Buildings and equipment, net
Total assets $790,800
Liabilities and Stockholders’ Equity
Current liabilities:
Accounts payable
Stockholders' equity:
Common stock
Retained earnings
0
Total liabilities and stockholders’ equity $0

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...

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