Questions
Manop, Inc. is facing a problem with their 4th quarter absorption costing net operating income on...

Manop, Inc. is facing a problem with their 4th quarter absorption costing net operating income on December 25. Their net operating income target is $250,000 and the data so far is as follows:

Sales Revenue

$600,000

($200/unit)

Variable COGS

$240,000

($80/unit)

Fixed manufacturing overhead

$70,000

Fixed S&A

$50,000

Variable S&A: Commission on Sales

3%

Finished Goods Inventory as of December 25

450 units

Up until this quarter, Manop, Inc. has had a policy of having zero inventories at the end of each quarter. No further sales are possible during the year. Mr. D, the CEO, is planning to produce more units for inventory in the last week of December to meet the net operating income target.

Q) How many additional inventory units above the December 25 Finished Goods balance need to be produced in the fourth quarter to meet the net operating income target if the sales commission is left unchanged? (Express your answer to the nearest whole number.)

In: Accounting

A company is interested in forecasting sales in the final quarter of the year based on...

A company is interested in forecasting sales in the final quarter of the year based on the first three quarters by fitting a linear regression model.

Sales: 215   268   344
Quarter: 1 2 3

What proportion of the variability in sales can be explained by the model?

Also predict the sales for the fourth quarter

In: Economics

The company has just hired a new marketing manager who insists that unit sales can be...

The company has just hired a new marketing manager who insists that unit sales can be dramatically increased by dropping the selling price from $8 to $7. The marketing manager would like to use the following projections in the budget:

  

  Data

Year 2 Quarter

Year 3 Quarter

1 2 3 4 1 2
  Budgeted unit sales 50,000 65,000 115,000 70,000 80,000 90,000
  Selling price per unit $7 per unit            

Chapter 7: Applying Excel

2
3 Data Year 2 Quarter Year 3 Quarter
4 1 2 3 4 1 2
5 Budgeted unit sales 50,000 65,000 115,000 70,000 80,000 90,000
6
7 � Selling price per unit $8 per unit
8 � Accounts receivable, beginning balance $65,000
9 � Sales collected in the quarter sales are made 75%
10 � Sales collected in the quarter after sales are made 25%
11 � Desired ending finished goods inventory is 30% of the budgeted unit sales of the next quarter
12 � Finished goods inventory, beginning 12,000 units
13 � Raw materials required to produce one unit 5 pounds
14 � Desired ending inventory of raw materials is 10% of the next quarter's production needs
15 � Raw materials inventory, beginning 23,000 pounds
16 � Raw material costs $0.80 per pound
17 � Raw materials purchases are paid 60% in the quarter the purchases are made
18      and 40% in the quarter following purchase
19 � Accounts payable for raw materials, beginning balance $81,500
20   

In: Accounting

The company has just hired a new marketing manager who insists that unit sales can be...

The company has just hired a new marketing manager who insists that unit sales can be dramatically increased by dropping the selling price from $8 to $7. The marketing manager would like to use the following projections in the budget: Data Year 2 Quarter Year 3 Quarter 1 2 3 4 1 2 Budgeted unit sales 45,000 65,000 105,000 60,000 90,000 90,000 Selling price per unit $7 per unit

A

B

C

D

E

F

F

1 Chapter 9: Applying Excel
2
3 Data Year 2 Quarter Year 3 Quarter
4 1 2 3 4 1 2
5 Budgeted unit sales 45,000 65,000 105,000 60,000 90,000 90,000
6
7 • Selling price per unit $7 per unit
8 • Accounts receivable, beginning balance $65,000
9 • Sales collected in the quarter sales are made 75%
10 • Sales collected in the quarter after sales are made 25%
11 • Desired ending finished goods inventory is 30% of the budgeted unit sales of the next quarter
12 • Finished goods inventory, beginning 12,000 units
13 • Raw materials required to produce one unit 5 pounds
14 • Desired ending inventory of raw materials is 10% of the next quarter's production needs
15 • Raw materials inventory, beginning 23,000 pounds
16 • Raw material costs $0.80 per pound
17 • Raw materials purchases are paid 60% in the quarter the purchases are made
18      and 40% in the quarter following purchase
19 • Accounts payable for raw materials, beginning balance $81,500

In: Accounting

1. Oxford Industries has the following sales forecasts for its snowshoes next year: First Quarter 24,000...

1. Oxford Industries has the following sales forecasts for its snowshoes next year: First Quarter 24,000 pairs Second Quarter 4 % increase over first quarter Third Quarter 5 % decrease from second quarter Fourth Quarter 7 % increase over first quarter What is Oxfords estimated sales revenue for next year if each pair sells for an average of $25? Multiple Choice $2,304,000. $2,400,000. $2,404,800. $2,458,800.

2.  

Item10

Time Remaining 30 minutes 47 seconds

00:30:47

Item 10

Item 10

Time Remaining 30 minutes 47 seconds

00:30:47

To derive the raw material to purchase during an accounting period, an accountant would calculate the raw material required for production and then:

Multiple Choice

  • add the beginning raw-material inventory and subtract the desired ending raw-material inventory.

  • add the desired ending raw-material inventory and subtract the beginning raw-material inventory.

  • add the desired ending raw-material inventory and subtract both the beginning raw-material inventory and the expected units to be sold.

  • add the beginning raw-material inventory and the desired ending raw-material inventory.

  • subtract the beginning raw-material inventory and the desired ending raw-material inventory.

In: Accounting

industries' balance sheet at December 31, 2015, is presented below. INDUSTRIES Balance Sheet December 31, 2015...

industries' balance sheet at December 31, 2015, is presented below.

INDUSTRIES
Balance Sheet
December 31, 2015
Assets
Current assets
    Cash $7,400
    Accounts receivable 82,000
    Finished goods inventory (1,500 units) 29,500
    Total current assets 118,900
Equipment $39,500
Less: Accumulated depreciation 10,000 29,500
        Total assets $148,400
Liabilities and Shareholders' Equity
Liabilities
    Notes payable $24,500
    Accounts payable 44,500
    Total liabilities 69,000
Shareholders’ equity
    Common stock $49,500
    Retained earnings 29,900
        Total shareholders’ equity 79,400
          Total liabilities and shareholders’ equity $148,400


Budgeted data for the year 2016 include the following.

Q4 of 2016

Year 2016 Total
Sales budget (8,000 units at $36) $86,400 $288,000
Direct materials used 16,500 69,500
Direct labor 12,000 55,500
Manufacturing overhead applied 10,000 28,000
Selling and administrative expenses 17,500 75,500

To meet sales requirements and to have 2,000 units of finished goods on hand at December 31, 2016, the production budget shows 8,500 required units of output. The total unit cost of production is expected to be $18. Kurian Industries uses the first-in, first-out (FIFO) inventory costing method. Selling and administrative expenses include $4,000 for depreciation on equipment. The company expects interest expense to be $3,000 for the year and income taxes to be 20% of income before income taxes.

All sales and purchases are on account. The company expects to collect 60% of the quarterly sales in cash within the quarter and the remainder in the following quarter. It pays direct materials purchased from suppliers 50% in the quarter incurred and the remainder in the following quarter. Purchases in the fourth quarter were the same as the materials used. In 2016, the company expects to purchase additional equipment costing $17,500. It expects to pay $7,500 on notes payable plus all interest due and payable to December 31 (included in interest expense $3,000, above). Accounts payable at December 31, 2016, includes amounts due to suppliers (see above) plus other accounts payable of $5,200. In 2016, the company expects to declare and pay a $4,500 cash dividend. Unpaid income taxes at December 31 will be $3,780. The company's cash budget shows an expected cash balance of $45,970 at December 31, 2016.

Prepare a budgeted balance sheet at December 31, 2016.

In: Accounting

Headquartered in Mumbai, India, Tata Motors is one of the largest multinational manufacturing companies. It manufactures...

Headquartered in Mumbai, India, Tata Motors is one of the largest multinational manufacturing companies.
It manufactures commercial and passenger vehicles—cars, trucks, vans, coaches, buses, construction
equipment, and military vehicles. Tata Motors has several auto manufacturing and assembly plants,
and research and development centers located across India, including in Jameshedpur, Lucknow, and
Pune. With a solid base in the country, Tata Motors has also built its operations in Argentina, South
Africa, Thailand, and the United Kingdom. In 2014, the company was ranked the world’s 287th biggest
corporation in Fortune’s Global 500 list. Marketing its products through dealership, sales, services, and
spare parts network, the company produces well-known models like the Nano, Safari, Aria, Zest, Bolt,
and Venture brand names, as well as Xenon XT brand name.
For a fourth straight quarter, the decline in China sales of Jaguar Land Rover (JLR), a subsidiary
of Tata Motors, dragged down the company’s profits. Jaguar’s net income fell 49 percent to 27.7 billion
rupees ($434 million) in the quarter ended in June, 2015. Its retail sales plunged 33 percent in
China that quarter, which lead to a 1 percent decline in worldwide deliveries. The luxury unit has cut
its sales targets and prices in China as all automakers brace for a slowdown in the world’s biggest auto
market. Tata Motors’ earnings for the second quarter of 2015 were also hurt by a prolonged slump in
sales of its light commercial vehicles in India. Tata’s revenue fell 5.7 percent to 610.2 billion rupees.
Sales at the luxury unit declined 6.5 percent to 5 billion pounds. Shares of Tata Motors stock has
slumped 29 percent over the past six months making it the second-worst performer on the S&P BSE
Sensex, which has lost 1.7 percent in the period. Sales of the Tata’s Evoque sport utility vehicle were
also lower in China.
The company’s vision statement, posted on the corporate website, states that by 2025, the company’s
commitment to delivering improved quality of life will be available to 25 percent of the global
population, making Tata one of the 25 most admired global brands and one of the most valuable companies
in the world. Its mission is to use its leadership experience, long-term value creation, and the
trust it has built to improve the quality of life of its consumers around the world.
Questions
1. How has the value of the Indian rupee changed compared to China’s yuan and the US dollar in
the last six months? How does this impact Tata?
2. In the About Us section of the company’s website, go to the corporate governance section and
click on the values and purpose link. Evaluate Tata’s vision and mission statement mentioned in
this section. Discuss the potential implications of Tata’s vision and mission on the firm’s competitive
advantages.

In: Economics

The production department of Hareston Company has submitted the following forecast of units to be produced...

The production department of Hareston Company has submitted the following forecast of units to be produced by quarter for the upcoming fiscal year:

  

1st Quarter 2nd Quarter 3rd Quarter 4th Quarter
  Units to be produced 8,500 9,500 7,500 6,500

In addition, the beginning raw materials inventory for the first quarter is budgeted to be 2,150 kilograms and the beginning accounts payable for the first quarter are budgeted to be $3,690.

    Each unit requires 3.5 kilograms of raw material that costs $2.90 per kilogram. Management desires to end each quarter with an inventory of raw materials equal to 10% of the following quarter’s production needs. The desired ending inventory for the fourth quarter is 2,625 kilograms. Management plans to pay for 80% of raw material purchases in the quarter acquired and 20% in the following quarter. Each unit requires 0.6 direct labour-hours, and direct labour-hour workers are paid $21.5 per hour.

  

Required:
1-a. Prepare the company's direct materials budget. (Round your answer to the nearest whole dollar amount.)

1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Year

Production needs (Kilograms)

Add: Desired Inventory

Total Needs (Kilograms)

Deduct: Beginning Inventory

Raw Materials to be purchased (Kilograms)

Cost of Raw Materials to be purchased

      

1-b.

Prepare the schedule of expected cash disbursements for materials for the upcoming fiscal year. (Round your answer to the nearest whole dollar amount.)

1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Year

Accounts Payable, Beginning Balance

1st Quarter Purchase

2nd Quarter Purchase

3rd Quarter Purchase

4th Quarter Purchase

Total Cash disbursements for material

     

2.

Prepare the company’s direct labour budget for the upcoming fiscal year, assuming that the direct labour workforce is adjusted each quarter to match the number of hours required to produce the forecasted number of units produced. (Do not round intermediate calculations.)

1st Quarter. 2ndQuarter. 3rd Quarter. 4th Quarter. Year

Total direct labour-hours needed

Total direct labour cost

In: Accounting

Patrick Inc. makes industrial solvents. In the first 4 months of the coming year, Patrick expects...

Patrick Inc. makes industrial solvents. In the first 4 months of the coming year, Patrick expects the following unit sales: January 41,000 February 38,000 March 50,000 April 51,000 Patrick's policy is to have 25% of next month's sales in ending inventory. On January 1, it is expected that there will be 6,700 drums of solvent on hand. Required: Prepare a production budget for the first quarter of the year. Show the number of drums that should be produced each month as well as for the quarter in total. Patrick Inc. Production Budget For the Coming Quarter January February March 1st Quarter Total Sales Desired ending inventory Total needs Less: Beginning inventory Units to be produced

In: Accounting

Calculate the present value of the following annuity streams: a. $7,000 received each year for 6...

Calculate the present value of the following annuity streams:

a. $7,000 received each year for 6 years on the last day of each year if your investments pay 6 percent compounded annually.
b. $7,000 received each quarter for 6 years on the last day of each quarter if your investments pay 6 percent compounded quarterly.
c. $7,000 received each year for 6 years on the first day of each year if your investments pay 6 percent compounded annually.
d. $7,000 received each quarter for 6 years on the first day of each quarter if your investments pay 6 percent compounded quarterly.

In: Finance