Questions
E13-6   Prepare production and direct materials budgets by quarters for 6 months. (LO 2), AP On...

E13-6  

Prepare production and direct materials budgets by quarters for 6 months.

(LO 2), AP

On January 1, 2017, the Hardin Company budget committee has reached agreement on the following data for the 6 months ending June 30, 2017.

  • Sales units: First quarter 5,000; second quarter 6,000; third quarter 7,000.
  • Ending raw materials inventory: 40% of the next quarter's production requirements.
  • Ending finished goods inventory: 25% of the next quarter's expected sales units.
  • Third-quarter production: 7,200 units.

The ending raw materials and finished goods inventories at December 31, 2016, follow the same percentage relationships to production and sales that occur in 2017. Three pounds of raw materials are required to make each unit of finished goods. Raw materials purchased are expected to cost $4 per pound.

Instructions

(a)

Prepare a production budget by quarters for the 6-month period ended June 30, 2017.

(b)

Prepare a direct materials budget by quarters for the 6-month period ended June 30, 2017.

In: Accounting

ACCOUNTING 203 ​​​​​​​NAMES: EXAM #3 (CH.8) 75 PTS. DUE DATE: Monday, February 26, 8:30 AM   ...

ACCOUNTING 203 ​​​​​​​NAMES:
EXAM #3 (CH.8)
75 PTS.
DUE DATE: Monday, February 26, 8:30 AM
  
The Grilton Tire Company manufactures racing tires for bicycles. Grilton sells tires for $50 each. Grilton is planning for next year by developing a master budget by quarters. Grilton’s balance sheet for December 31, 2016 follows:
PLEASE DO NOT ROUND !!!!

GRILTON TIRE COMPANY
Balance Sheet
December 31, 2016
Assets
Current Assets:
Cash $ 39,000
Accounts Receivable 40,000
Raw Materials Inventory 2,400
Finished Goods Inventory 8,700
Total Current Assets $ 90,100
Property, Plant and Equipment:
Equipment 177,000
Less: Accumulated Depreciation (42,000) 135,000
Total Assets $225,100
Liabilities
Current Liabilities:
Accounts Payable $ 8,000
Stockholder’s Equity
Common Stock, no par $ 130,000
Retained Earnings 87,100
Total Stockholder’s Equity 217,100
Total Liabilities and Stockholder’s Equity $225,100
Other data for Grilton Tire Company:
a. Budgeted Sales are 1,500 for the first quarter and expected to increase by 200 tires per quarter. Cash Sales are expected to be 30% of total sales, with the remaining 70% of sales on account.
b. Finished Goods Inventory on December 31, 2016 consists of 300 tires at $29 each.
c. Desired ending Finished Goods Inventory is 40% of the next quarter’s sales; first quarter sales for 2018 are expected to be 2,300 tires and second quarter sales for 2018 are expected to be 2,500. FIFO inventory costing method is used.
d. Direct Materials cost is $8 per tire.
e. Desired ending Raw Materials Inventory is 30% of the next quarter’s direct materials needed for production.
f. Each tire requires 0.40 hours of direct labor; direct labor costs average $16 per hour.
g. Variable manufacturing overhead is $2 per tire produced.
h. Fixed manufacturing overhead includes $4,500 per quarter in depreciation and $26,780 per quarter for other costs, such as utilities, insurance, and property taxes.
i. Fixed selling and administrative expenses include $8,000 per quarter for salaries; $1,800 per quarter for rent; $1,200 per quarter for insurance; and $500 per quarter for depreciation.
j. Variable selling and administrative expenses include supplies at 2% of sales.
k. Capital expenditures include $45,000 for new manufacturing equipment, to be purchased and paid in the first quarter.
l. Cash receipts for sales on account are 60% in the quarter of sale and 40% in the quarter following the sale; December 31, 2016, Accounts Receivable is received in the first quarter of 2017.
m. Direct materials purchases are paid 70% in the quarter purchased and 30% in the following quarter; December 31, 2016, Accounts Payable is paid in the first quarter of 2017.
n. Direct labor, manufacturing overhead, and selling and administrative costs are paid in the quarter incurred.
o. Income tax expense is projected at $3,500 per quarter and is paid in the quarter incurred.
p. Grilton desires to maintain a minimum cash balance of $35,000 and borrows from the local bank as needed in increments of $1,000 at the beginning of the quarter; principal repayments are made at the beginning of the quarter when excess funds are available and in increments of $1,000; interest is 6% per year and paid at the beginning of the quarter based on the amount outstanding from the previous quarter.
REQUIREMENTS:
1. Prepare a sales budget in units and dollars for each quarter and in total for the year 2017. (5 pts.)
2. Prepare a schedule of expected cash collections for each quarter and in total for the year 2017. (5 pts.)
3. Prepare a production budget for each quarter and in total for the year 2017. (5 pts.)
4. Prepare a direct materials budget for each quarter and in total for the year 2017. (5 pts.)
5. Prepare a schedule of expected cash disbursements for purchases of materials for each quarter and in total of the year 2017. (5 pts.)
6. Prepare a budgeted Schedule of Cost of Goods Manufactured for the year of 2017. (5 pts.)
7. Prepare a budgeted Income Statement for the year of 2017 (5 pts.)
8. Prepare a cash budget for the year of 2017. (15 pts.
9. Essay: What types of information do your budgets yield? Is cash flow adequate? Do sales need to be increased, costs reduced? Etc….. ( 10 pts.)
10. On time (20 pts.)

In: Accounting

After reading the article below, make sure to answer the following questions 1. List three ways...

After reading the article below, make sure to answer the following questions

1. List three ways in which the U.S. economy has shown strength in 2019.

2. How many years has it now been since the United States last experienced a recession?

3. What are two signs that the U.S. economy may be slowing down in the second quarter? Please give a 3 sentence explanation of each sign.Do these appear to be one-time issues or do they potentially mark the start of a longer downturn Make sure to explain your answer.


U.S. ECONOMY LOST SOME STEAM AT START OF SECOND QUARTER

 

The U.S. economy got off to a sluggish start in the second quarter, with both consumers and manufacturers pulling back in April amid trade tensions, a global slowdown and waning effects of the 2017 tax cuts.

Retail sales (Links to an external site.) fell a seasonally adjusted 0.2% in April from the previous month, the Commerce Department said Wednesday, driven by declines in categories such as electronics, home improvement, motor vehicles, auto parts and at online shopping businesses.

Factory output (Links to an external site.) dropped a steeper 0.5% in April from March, according to Federal Reserve data, the third monthly decline in the past four months. It was down 2.1% in the first quarter on an annualized basis.

A closely watched measure of U.S. freight demand also is sending a troubling signal. The Cass Freight Index for shipments dropped 3.2% in April, the fifth straight month in negative territory. The authors of the report, Cass Information Systems, said the numbers signal “material and growing downside risk to the economic outlook.”

Together, the reports suggest the U.S. economy lost momentum after growing at a 3.2% annual rate (Links to an external site.) in the first quarter.

Macroeconomic Advisers, a forecasting firm, lowered its second-quarter economic growth estimate to a 2% rate from 2.1% in response. Oxford Economics lowered its forecast to a 1.6% pace from 1.7%.

Economists had expected the second quarter to be weaker than the first, when output was buoyed in part by a decline in imports and an increase in inventories, offsetting weaker gains in consumer spending and business investment. But the new data suggested there could be “maybe a little more of a step down than we initially thought,” said Michael Feroli, chief economist at J.P. Morgan.

Overall, the U.S. economy remains strong. Employers added 263,000 jobs  (Links to an external site.)in April, unemployment reached a near-50-year low and wages continued to inch up—all encouraging signs for household pocketbooks. Economists warned against overreacting to Wednesday’s batch of wobbly data.

“As long as the labor market holds in, I don’t think it’s an existential issue for the expansion,” which began nearly 10 years ago, said Mr. Feroli.

If he is right, the U.S. economy in June will mark a decade without a recession, the longest stretch on record. “I think we’re going to make it to our 10th birthday,” he said.

The fall in retail sales could be partly because tax refunds weren’t as generous as consumers expected, perhaps prompting households to put off major purchases, he said.

Sales have been volatile in recent months, dropping in February before bouncing back in March (Links to an external site.).

Economists also saw the April retail-sales decline as a sign that households might be rattled by the trade dispute between the U.S. and China. Last week President Trump said that tariffs on $200 billion in Chinese goods would rise to 25% from 10%. The president left open the possibility of additional actions. China retaliated (Links to an external site.) by raising tariffs on $60 billion of U.S. imports.

As the stimulus from recent tax cuts and increased federal spending dissipates and the trade fight escalates, “you’re going to see stronger headwinds that will curb growth in consumer spending,” said Gregory Daco, chief U.S. economist at Oxford Economics.

Some of the recent manufacturing contraction is likely due to the large buildup in inventories in the first quarter, analysts said. That means factories don’t need to produce as much to meet demand.

But the persistent weakness since the start of the year suggests American factories have been squeezed by trade tensions, a weaker global economy and a strong dollar, which makes U.S. exports more expensive in world markets.

“I don’t think there’s any way to put lipstick on the manufacturing numbers,” said Joshua Shapiro, chief U.S. economist at MFR Inc. “The growth isn’t there. The domestic demand in the U.S. is pretty decent, but export demand is weakening.”

At Thomaston Mills, a bedsheet maker in Thomaston, Ga., production is slower this year because orders are down. Custom orders for the company’s bedding and towels typically rise when hoteliers are confident in the economy, said plant manager Jimmy Bond.

Notebook maker Top Flight Inc. recently received a big order that will boost production for the first time in several years, said Chief Operating Officer Wejun Robinson.

But rising costs for paper, overtime and imports as a result of tariffs on goods from China are hurting the Chattanooga, Tenn.-based company’s profit, he said. Top Flight’s margins will be even thinner than expected after the Trump administration increased tariffs on goods including some notebook varieties it doesn’t make in the U.S. to 25% last Friday from 10% previously.

“We priced our products at the 10% rate,” Mr. Robinson said. “It will make a difference.”

Important U.S. trading partners such as China and Germany are going through a volatile period as fears of a broader trade war depress confidence.

Growth in Chinese retail sales, industrial output and investment in fixed assets slowed (Links to an external site.) in April despite a heavy dose of government stimulus. 

In Germany, new factory orders are slowing and major manufacturers such as Continental (Links to an external site.)AG and Daimler (Links to an external site.) AG posted lower first-quarter earnings. But domestic consumption and a strong construction sector helped support the German economy (Links to an external site.) in the first quarter.

 

In: Economics

The indices of refraction for the fast and slow axes of quartz with 589 nm light...

  1. The indices of refraction for the fast and slow axes of quartz with 589 nm light are 1.5462 and 1.5553, respectively.

    1. (a) By what fraction of a wavelength is the e-ray retarded, relative to the o-ray, for every

      wavelength of travel in quartz?

    2. (b) What is the minimum thickness of quartz needed to manufacture a quarter-wave plate

      (QWP)?

    3. (c) Imagine that the thickness found in part (b) turned out to be too thin for the QWP to be

      durable and you want to manufacture a QWP with a thickness of at least 0.725 mm. What will be the thickness of the thinnest possible QWP that will be larger than 0.725 mm?

In: Physics

Chapter 9: Applying Excel Data Year 2 Quarter Year 3 Quarter 1 2 3 4 1...

Chapter 9: Applying Excel
Data Year 2 Quarter Year 3 Quarter
1 2 3 4 1 2
Budgeted unit sales 40,000 60,000 100,000 50,000 70,000 80,000
• Selling price per unit $8 per unit
• Accounts receivable, beginning balance $65,000
• Sales collected in the quarter sales are made 75%
• Sales collected in the quarter after sales are made 25%
• Desired ending finished goods inventory is 30% of the budgeted unit sales of the next quarter
• Finished goods inventory, beginning 12,000 units
• Raw materials required to produce one unit 5 pounds
• Desired ending inventory of raw materials is 10% of the next quarter's production needs
• Raw materials inventory, beginning 23,000 pounds
• Raw material costs $0.80 per pound
• Raw materials purchases are paid 60% in the quarter the purchases are made
and 40% in the quarter following purchase
• Accounts payable for raw materials, beginning balance $81,500
Enter a formula into each of the cells marked with a ? below
Review Problem: Budget Schedules
Construct the sales budget Year 2 Quarter Year 3 Quarter
1 2 3 4 1 2
Budgeted unit sales ? ? ? ? ? ?
Selling price per unit ? ? ? ? ? ?
Total sales ? ? ? ? ? ?
Construct the schedule of expected cash collections Year 2 Quarter
1 2 3 4 Year
Accounts receivable, beginning balance ? ?
First-quarter sales ? ? ?
Second-quarter sales ? ? ?
Third-quarter sales ? ? ?
Fourth-quarter sales ? ?
Total cash collections ? ? ? ? ?
Construct the production budget Year 2 Quarter Year 3 Quarter
1 2 3 4 Year 1 2
Budgeted unit sales ? ? ? ? ? ? ?
Add desired finished goods inventory ? ? ? ? ? ?
Total needs ? ? ? ? ? ?
Less beginning inventory ? ? ? ? ? ?
Required production ? ? ? ? ? ?
Construct the raw materials purchases budget Year 2 Quarter Year 3 Quarter
1 2 3 4 Year 1
Required production (units) ? ? ? ? ? ?
Raw materials required to produce one unit ? ? ? ? ? ?
Production needs (pounds) ? ? ? ? ? ?
Add desired ending inventory of raw materials (pounds) ? ? ? ? ?
Total needs (pounds) ? ? ? ? ?
Less beginning inventory of raw materials (pounds) ? ? ? ? ?
Raw materials to be purchased ? ? ? ? ?
Cost of raw materials per pound ? ? ? ? ?
Cost of raw materials to be purchased ? ? ? ? ?
Construct the schedule of expected cash payments Year 2 Quarter
1 2 3 4 Year
Accounts payable, beginning balance ? ?
First-quarter purchases ? ? ?
Second-quarter purchases ? ? ?
Third-quarter purchases ? ? ?
Fourth-quarter purchases ? ?
Total cash disbursements ? ? ? ? ?

Check your worksheet by changing the budgeted unit sales in Quarter 2 of Year 2 in cell C5 to 75,000 units. The total expected cash collections for the year should now be $2,085,000. If you do not get this answer, find the errors in your worksheet and correct them.

plz show the fomula for caculation

In: Accounting

Pargo Company is preparing its master budget for 2017. Relevant data pertaining to its sales, production, and direct materials budgets are as follows.

Do It! Review 21-2

Your answer is partially correct. Try again.

Pargo Company is preparing its master budget for 2017. Relevant data pertaining to its sales, production, and direct materials budgets are as follows.

Sales. Sales for the year are expected to total 2,000,000 units. Quarterly sales are 22%, 26%, 27%, and 25%, respectively. The sales price is expected to be $40 per unit for the first three quarters and $47 per unit beginning in the fourth quarter. Sales in the first quarter of 2018 are expected to be 15% higher than the budgeted sales for the first quarter of 2017.

Production. Management desires to maintain the ending finished goods inventories at 25% of the next quarter’s budgeted sales volume.

Direct materials. Each unit requires 2 pounds of raw materials at a cost of $11 per pound. Management desires to maintain raw materials inventories at 10% of the next quarter’s production requirements. Assume the production requirements for first quarter of 2018 are 498,000 pounds.

Prepare the sales, production, and direct materials budgets by quarters for 2017.

In: Accounting

Oak Creek Company is preparing its master budget for 2020. Relevant data pertaining to its sales,...

Oak Creek Company is preparing its master budget for 2020. Relevant data pertaining to its sales, production, and direct materials budgets are as follows.

Sales: Sales for the year are expected to total 1,000,000 units. Quarterly sales are 20%, 25%, 25%, and 30%, respectively. The sales price is expected to be $40 per unit for the first three quarters and $46 per unit beginning in the fourth quarter. Sales in the first quarter of 2021 are expected to be 10% higher than the budgeted sales for the first quarter of 2020.

Production: Management desires to maintain the ending finished goods inventories at 20% of the next quarter's budgeted sales volume.

Direct materials: Each unit requires 2 kg of raw materials at a cost of $10 per kilogram. Management desires to maintain raw materials inventories at 10% of the next quarter's production requirements. Assume the production requirements for the first quarter of 2021 are 630,000 kg.

1. Prepare the sales budget by quarters for 2020.

2. Prepare the production budget by quarters for 2020.

3. Prepare the direct materials budget by quarters for 2020.

In: Accounting

When the economy is in recession, government revenue falls due to a falling tax base. Therefore...

When the economy is in recession, government revenue falls due to a falling tax base. Therefore the proper role of government should be to increase taxes and cut spending so as to balance the Federal budget. Do you agree? Why?

“Money not backed by gold or silver is worthless paper and is a fraud committed against the people of the United States.” Critically evaluate this statement.

In: Economics

When the economy is in recession, government revenue falls due to a falling tax base. Therefore...

  1. When the economy is in recession, government revenue falls due to a falling tax base. Therefore the proper role of government should be to increase taxes and cut spending so as to balance the Federal budget. Do you agree? Why?
  2. “Money not backed by gold or silver is worthless paper and is a fraud committed against the people of the United States.” Critically evaluate this statement.

In: Economics

Read the following article. U.S. Pork Prices Hit Multi-Year Low MINTEC, 10 Sept 2018 Pork prices...

Read the following article.

U.S. Pork Prices Hit Multi-Year Low

MINTEC, 10 Sept 2018

Pork prices in the U.S. have fallen sharply since June, with August prices 40% lower month-over-month, which shows that pork prices are falling at a more significant rate than the historical average.

Current prices are at a multi-year low why are prices falling faster than expected?

First, pork production is currently higher than last year, with low feed costs stimulating production. Additionally, the introduction of three new packing plants in Minnesota, Iowa and Michigan in late 2017 meant herds grew to meet the new packing capacity.

Along with increasing pork volumes in the U.S. market, rising supplies of beef and poultry mean that there are vaster meat supplies to compete for consumer spending with, eventually weighing down on pork prices.

But perhaps most significant, retaliatory tariffs from China on U.S. pork are driving down prices. The export market is a substantial destination for U.S. pork. In particular, China is a top consumer of U.S. pork, this retaliatory policy has hampered U.S. export growth further.

***************************************************************************************************************************************************************************************************

Some factors could affect the demand for and supply of pork in the U.S.

Draw THREE separate demand-and-supply diagrams for each of the factors mentioned in the above article, and show their respective impacts on the market price and quantity of pork in the U.S. State clearly which factors or events are associated with the changes in demand or supply in each of your three diagrams. Briefly explain your answer.

*****Microeconomics******Please clearly answer the question with detailed steps*******I just started to learn microeconomics***please assist me, thank you

In: Economics