Questions
pictou pallets manufatures shipping pallets at two plants and distributes them to three strategically located warehouses....

pictou pallets manufatures shipping pallets at two plants and distributes them to three strategically located warehouses.

Plant 1 is capable of producing 8000 pallets per year and plant 2 is capable of producing 5000 pallets per year.

Warehouse A requires 4500 pallets, warehouse b requires 3000 pallets, and warehouse c requires 4000 pallets per year.

the cost of shipping one pallet from each plant to each warehouse are listed below:

(eg. the cost of shipping from plant 1 to warehouse A is $1.10 per pallet)

plant warehouse a warehouse b warehouse c
1 $1.10 $1.40 $1.25
2 $1.20 $0.95 $1.00

a) find the optimal shipping schedule to minimize shipping costs.

B) would the shipping schedule change if the cost of shipping from plant 1 to warehouse A increased by $0.30 to $1.40? explain

C) how much would the shipping charges change if plant 2's capacity were decreased by 100 pallets?

d) would the same hold for another decrease of 100 pallets?

E) the optimal shipping schedule has no pallets shipped from plant 1 to warehouse b. What change in shipping cost along this route would make such shipments worthwhile.

Please solve in Excel

In: Accounting

Warnerwoods Company uses a perpetual inventory system. It entered into the following purchases and sales transactions...

Warnerwoods Company uses a perpetual inventory system. It entered into the following purchases and sales transactions for March.

Date Activities Units Acquired at Cost Units Sold at Retail
Mar. 1 Beginning inventory 160 units @ $52.20 per unit
Mar. 5 Purchase 255 units @ $57.20 per unit
Mar. 9 Sales 320 units @ $87.20 per unit
Mar. 18 Purchase 115 units @ $62.20 per unit
Mar. 25 Purchase 210 units @ $64.20 per unit
Mar. 29 Sales 190 units @ $97.20 per unit
Totals 740 units 510 units

Compute the cost assigned to ending inventory using LIFO.

Perpetual LIFO:
Goods Purchased Cost of Goods Sold Inventory Balance
Date # of units Cost per unit # of units sold Cost per unit Cost of Goods Sold # of units Cost per unit Inventory Balance
March 1 160 @ $52.20 = $8,352.00
March 5
March 9
March 18
March 25
March 29
Totals $0.00


In: Accounting

Silver Company makes a product that is very popular as a Mother’s Day gift. Thus, peak...

Silver Company makes a product that is very popular as a Mother’s Day gift. Thus, peak sales occur in May of each year, as shown in the company’s sales budget for the second quarter given below:

April May June Total
Budgeted sales (all on account) $480,000 $680,000 $260,000 $1,420,000

From past experience, the company has learned that 30% of a month’s sales are collected in the month of sale, another 60% are collected in the month following sale, and the remaining 10% are collected in the second month following sale. Bad debts are negligible and can be ignored. February sales totaled $410,000, and March sales totaled $440,000.

Required:

1. Prepare a schedule of expected cash collections from sales, by month and in total, for the second quarter.

2. What is the accounts receivable balance on June 30th?

In: Accounting

he direct labor budget of Yuvwell Corporation for the upcoming fiscal year contains the following details...

he direct labor budget of Yuvwell Corporation for the upcoming fiscal year contains the following details concerning budgeted direct labor-hours:

1st Quarter 2nd Quarter 3rd Quarter 4th Quarter
Budgeted direct labor-hours 11,200 9,800 10,100 10,900

The company uses direct labor-hours as its overhead allocation base. The variable portion of its predetermined manufacturing overhead rate is $6.00 per direct labor-hour and its total fixed manufacturing overhead is $80,000 per quarter. The only noncash item included in fixed manufacturing overhead is depreciation, which is $20,000 per quarter.

Required:

1. Prepare the company’s manufacturing overhead budget for the upcoming fiscal year.

2. Compute the company’s predetermined overhead rate (including both variable and fixed manufacturing overhead) for the upcoming fiscal year.

In: Accounting

VanderMeer Inc. reported the following information for the month of February: Inventory, February 1 57 units...

VanderMeer Inc. reported the following information for the month of February:

Inventory, February 1 57 units @ $20
Purchase:
February 7 48 units @ $22
February 18 67 units @ $24
February 27 38 units @ $26

During February, VanderMeer sold 136 units. The company uses a periodic inventory system.

Required:

What is the value of ending inventory and cost of goods sold for February under the following assumptions.

Assumption Cost of Goods Sold Ending Inventory
1. Of the 136 units sold, 48 cost $20, 34 cost $22, 50 cost $24, and 4 cost $26. $ $
2. FIFO $ $
3. LIFO $ $
4. Weighted average method (Round average unit cost to the nearest cent,
and round all other calculations and your final answers to the nearest dollar.)
$ $

In: Accounting

The Two Dollar Store has a cost of equity of 10.9 percent, the YTM on the...

The Two Dollar Store has a cost of equity of 10.9 percent, the YTM on the company's bonds is 5.6 percent, and the tax rate is 40 percent. If the company's debt–equity ratio is .45, what is the weighted average cost of capital?

a-8.56%

b- 9.13%

c- 5.70%

d- 8.21%

e- 7.53% (NOT CORRECT)

Dyrdek Enterprises has equity with a market value of $12.7 million and the market value of debt is $4.50 million. The company is evaluating a new project that has more risk than the firm. As a result, the company will apply a risk adjustment factor of 2.2 percent. The new project will cost $2.58 million today and provide annual cash flows of $671,000 for the next 6 years. The company's cost of equity is 11.83 percent and the pretax cost of debt is 5.07 percent. The tax rate is 35 percent. What is the project's NPV?

a- $192,088 .(NOT CORRECT)

b- $377,207

c- $579,510

d- $194,678

e- $158,451

In: Accounting

Amanda Ltd is a manufacturing company operating in Parramatta, Sydney. The company has been successful since...

Amanda Ltd is a manufacturing company operating in Parramatta, Sydney. The company has been successful since its inception in the early 1990 and has even won twice the “Best Corporate Citizen Award” presented by the City of Parramatta Council. The company has recently been facing multiple problems including declining profit, loss of inventory (through theft or spoilage) in the warehouse, and declining reputation from its stakeholders. Coincidently, all these problems started when the head of Accounting Department, Sofia Bryant, voluntarily retired from her position recently. Her retirement was provoked by a sarcastic comment made by the Sales Manager during board meeting, that “Amanda Ltd can cut down its cost by shutting down Accounting Department. After all we will even be better off without this department”.

Part A

1. Evaluate the statement, “Accounting is the Language of Business”.

2. Discuss how Accounting and Governance helped Amanda Ltd in winning the Best Corporate Citizen Award.

Part B

3. a. Why some firms might prefer a perpetual inventory system to a period inventory system?

b. Explain how using perpetual inventory system could help Amanda Ltd to minimise the loss of inventory.

4. How would the application of the principle of segregation of duties could prevent the loss of inventory at Amanda LTD?

In: Accounting

The controller of Dash Shoes Inc. instructs you to prepare a monthly cash budget for the...

The controller of Dash Shoes Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information:

March April May
Sales $115,000 $137,000 $196,000
Manufacturing costs 48,000 59,000 71,000
Selling and administrative expenses 33,000 37,000 43,000
Capital expenditures _ _ 47,000

The company expects to sell about 15% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the sale and the remainder the following month (second month following sale). Depreciation, insurance, and property tax expense represent $6,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in July, and the annual property taxes are paid in November. Of the remainder of the manufacturing costs, 75% are expected to be paid in the month in which they are incurred and the balance in the following month.

Current assets as of March 1 include cash of $44,000, marketable securities of $62,000, and accounts receivable of $128,600 ($101,000 from February sales and $27,600 from January sales). Sales on account for January and February were $92,000 and $101,000, respectively. Current liabilities as of March 1 include a $58,000, 12%, 90-day note payable due May 20 and $6,000 of accounts payable incurred in February for manufacturing costs. All selling and administrative expenses are paid in cash in the period they are incurred. It is expected that $3,500 in dividends will be received in March. An estimated income tax payment of $16,000 will be made in April. Dash Shoes' regular quarterly dividend of $6,000 is expected to be declared in April and paid in May. Management desires to maintain a minimum cash balance of $34,000.

Required:

1. Prepare a monthly cash budget and supporting schedules for March, April, and May. Input all amounts as positive values except overall cash decrease and deficiency which should be indicated with a minus sign. Assume 360 days per year for interest calculations.

Dash Shoes Inc.
Cash Budget
For the Three Months Ending May 31, 2016
March April May
Estimated cash receipts from:
Cash sales $ $ $
Collection of accounts receivable
Dividends
Total cash receipts $ $ $
Estimated cash payments for:
Manufacturing costs $ $ $
Selling and administrative expenses
Capital expenditures
Other purposes:
Note payable (including interest)
Income tax
Dividends
Total cash payments $ $ $
Cash increase or (decrease) $ $ $
Cash balance at beginning of month
Cash balance at end of month $ $ $
Minimum cash balance
Excess or (deficiency) $ $ $

In: Accounting

The following information is available concerning the inventory of Carter Inc.: Units Unit Cost Beginning inventory...

The following information is available concerning the inventory of Carter Inc.:

Units Unit Cost
Beginning inventory 206 $10
Purchases:
   March 5 299 11
   June 12 402 12
   August 23 254 13
   October 2 150 15

During the year, Carter sold 994 units. It uses a periodic inventory system.

Required:

1. Calculate ending inventory and cost of goods sold for each of the following three methods:

In your calculations round average unit cost to the nearest cent, and round all other calculations and your final answers to the nearest dollar.

Cost Flow Assumption Ending Inventory Cost of Goods Sold
a. Weighted average $ $
b. FIFO $ $
c. LIFO $ $

2. Assume an estimated tax rate of 30%. How much more or less (indicate which) will Carter pay in taxes by using FIFO instead of LIFO?

Difference in taxes under FIFO vs. LIFO $

In: Accounting

On January 1, a company issues bonds with a par value of $500,000. The bonds mature...

On January 1, a company issues bonds with a par value of $500,000. The bonds mature in 5 years. The contract rate is 9%, and interest is paid semiannually on June 30 and December 31. The market rate is 12%. Calculate the sale price and record the journal entry for this sale. Using the straight-line method, calculate the amount of interest expense for the first semiannual interest period and record the journal entry.

In: Accounting

Write the General Ledger and Reporting General Controls used in companies to overcome the threats. (3...

  1. Write the General Ledger and Reporting General Controls used in companies to overcome the threats.

In: Accounting

Swifty Company uses a perpetual inventory system. Its beginning inventory consists of 58 units that cost...

Swifty Company uses a perpetual inventory system. Its beginning inventory consists of 58 units that cost $39 each. During June, (1) the company purchased 173 units at $39 each on account, (2) returned 7 units for credit, and (3) sold 144 units at $58 each.

Journalize the June transactions. (If no entry is required, select "No entry" for the account titles and enter 0 for the amounts. Credit account titles are automatically indented when amount is entered. Do not indent manually.)

No.

Account Titles and Explanation

Debit

Credit

(1)

enter an account title

enter a debit amount

enter a credit amount

enter an account title

enter a debit amount

enter a credit amount

(2)

enter an account title

enter a debit amount

enter a credit amount

enter an account title

enter a debit amount

enter a credit amount

(3)

enter an account title to record sales

enter a debit amount

enter a credit amount

enter an account title to record sales

enter a debit amount

enter a credit amount

(To record sales)

enter an account title to record cost of goods sold

enter a debit amount

enter a credit amount

enter an account title to record cost of goods sold

In: Accounting

Trident Repairs & Service, an electronics repair store, prepared the following unadjusted trial balance at the...

Trident Repairs & Service, an electronics repair store, prepared the following unadjusted trial balance at the end of its first year of operations:

Trident Repairs & Service

UNADJUSTED TRIAL BALANCE

November 30, 20Y3

ACCOUNT TITLE DEBIT CREDIT

1

Cash

9,880.00

2

Accounts Receivable

67,550.00

3

Supplies

16,160.00

4

Equipment

114,550.00

5

Accounts Payable

15,790.00

6

Unearned Fees

17,600.00

7

Common Stock

9,500.00

8

Retained Earnings

112,710.00

9

Dividends

13,210.00

10

Fees Earned

291,830.00

11

Wages Expense

94,040.00

12

Rent Expense

71,870.00

13

Utilities Expense

52,130.00

14

Miscellaneous Expense

8,040.00

15

Totals

447,430.00

447,430.00

For preparing the adjusting entries, the following data were assembled:

Fees earned but unbilled on November 30 were $9,890.
Supplies on hand on November 30 were $4,770.
Depreciation of equipment was estimated to be $6,470 for the year.
The balance in unearned fees represented the November 1 receipt in advance for services to be provided. During November, $15,120 of the services were provided.
Unpaid Wages accrued on November 30 were $5,280.
Required:
1. Journalize the adjusting entries necessary on November 30, 20Y3. Refer to the Chart of Accounts for exact wording of account titles.
2. Determine the revenues, expenses, and net income of Trident Repairs & Service before the adjusting entries.
3. Determine the revenues, expenses, and net income of Trident Repairs & Service after the adjusting entries.
4. Determine the effect of the adjusting entries on Retained Earnings.
CHART OF ACCOUNTS
Trident Repairs & Service
General Ledger
ASSETS
11 Cash
12 Accounts Receivable
13 Supplies
14 Equipment
15 Accumulated Depreciation-Equipment
LIABILITIES
21 Accounts Payable
22 Wages Payable
23 Unearned Fees
EQUITY
31 Common Stock
32 Retained Earnings
33 Dividends
REVENUE
41 Fees Earned
EXPENSES
51 Wages Expense
52 Rent Expense
53 Supplies Expense
54 Depreciation Expense
56 Utilities Expense
59 Miscellaneous Expense

1. Journalize the adjusting entries necessary on November 30, 20Y3. Refer to the Chart of Accounts for exact wording of account titles.

PAGE 10

JOURNAL

ACCOUNTING EQUATION

DATE DESCRIPTION POST. REF. DEBIT CREDIT ASSETS LIABILITIES EQUITY

1

Adjusting Entries

2

3

4

5

6

7

8

9

10

11

2. Determine the revenues, expenses, and net income of Trident Repairs & Service before the adjusting entries.

Before Adjusting Entries

1

Revenues

2

Expenses

3

Net income

3. Determine the revenues, expenses, and net income of Trident Repairs & Service after the adjusting entries.

After Adjusting Entries

1

Revenues

2

Expenses

3

Net income

4. Determine the effect of the adjusting entries on Retained Earnings.

The Retained Earnings account increases by $ _____________

In: Accounting

Beth R. Jordan lives at 2322 Skyview Road, Mesa, AZ 85201. She is a tax accountant...

Beth R. Jordan lives at 2322 Skyview Road, Mesa, AZ 85201. She is a tax accountant with Mesa Manufacturing Company, 1203 Western Avenue, Mesa, AZ 85201 (employer identification number 11-1111111). She also writes computer software programs for tax practitioners and has a part-time tax practice. Beth is single and has no dependents. Beth was born on July 4, 1973, and her Social Security number is 123-45-6785. She wants to contribute $3 to the Presidential Election Campaign Fund.

The following information is shown on Beth's Wage and Tax Statement (Form W–2) for 2019.

Line Description Amount
1 Wages, tips, other compensation $65,000.00
2 Federal income tax withheld 9,500.00
3 Social Security wages 65,000.00
4 Social Security tax withheld 4,030.00
5 Medicare wages and tips 65,000.00
6 Medicare tax withheld 942.50
15 State Arizona
16 State wages, tips, etc. 65,000.00
17 State income tax withheld 1,954.00

During the year, Beth received interest of $1,300 from Arizona Federal Savings and Loan and $400 from Arizona State Bank. Each financial institution reported the interest income on a Form 1099–INT. She received qualified dividends of $800 from Blue Corporation, $750 from Green Corporation, and $650 from Orange Corporation. Each corporation reported Beth's dividend payments on a Form 1099–DIV.

Beth received a $1,100 income tax refund from the state of Arizona on April 29, 2019. On her 2018 Federal income tax return, she used the standard deduction.

Fees earned from her part-time tax practice in 2019 totaled $3,800. She paid $600 to have the tax returns processed by a computerized tax return service.

On February 8, 2019, Beth bought 500 shares of Gray Corporation common stock for $17.60 a share. On September 12, 2019, Beth sold the stock for $14 a share.

Beth bought a used sport utility vehicle for $6,000 on June 5, 2019. She purchased the vehicle from her brother-in-law, who was unemployed and was in need of cash. On November 2, 2019, she sold the vehicle to a friend for $6,500.

On January 2, 2019, Beth acquired 100 shares of Blue Corporation common stock for $30 a share. She sold the stock on December 19, 2019, for $55 a share.

During the year, Beth records revenues of $16,000 from the sale of a software program she developed. Beth incurred the following expenses in connection with her software development business.

Cost of personal computer $7,000
Cost of printer 2,000
Furniture 3,000
Supplies 650
Fee paid to computer consultant 3,500

Beth elected to expense the maximum portion of the cost of the computer, printer, and furniture allowed under the provisions of § 179. These items were placed in service on January 15, 2019, and used 100% in her business.

Although her employer suggested that Beth attend a convention on current developments in corporate taxation, Beth was not reimbursed for the travel expenses of $1,420 she incurred in attending the convention. The $1,420 included $200 for the cost of meals.

During the year, Beth paid $300 for prescription medicines and $2,875 for doctor interest to credit card bills and hospital bills. Medical insurance premiums were paid for her by her employer. Beth paid real property taxes of $1,766 on her home. Interest on her home mortgage (Valley National Bank) was $3,845, and interest to credit card companies was $320. Beth contributed $2,080 to various qualifying charities during the year. Professional dues and subscriptions totaled $350.

Beth paid estimated taxes of $1,000. Beth does not own or use any virtual currency.

Required:

Compute the net tax payable or refund due for Beth R. Jordan for 2019.

In: Accounting

ABC Versus ABM Harvey Company produces two models of blenders: the “Super Model” (priced at $399)...

  1. ABC Versus ABM

    Harvey Company produces two models of blenders: the “Super Model” (priced at $399) and the “Special Model” (priced at $201). Recently, Harvey has been losing market share with its Special Model because of competitors offering blenders with the same quality and features but at a lower price. A careful market study revealed that if Harvey could reduce the price of its Special Model to $181, it would regain its former share of the market. Management, however, is convinced that any price reduction must be accompanied by a cost reduction of the same amount so that per-unit profitability is not affected. Earl Wise, company controller, has indicated that poor overhead costing assignments may be distorting management’s view of each product’s cost and, therefore, the ability to know how to set selling prices. Earl has identified the following overhead activities: machining, inspection, and rework. The three activities, their costs, and practical capacities are as follows:

    Activity Cost Practical Capacity
    Machining $5,310,000      88,500 machine hours
    Inspection 3,393,000      43,500 inspection hours
    Rework 1,822,800      43,400 rework hours

    The consumption patterns of the two products are as follows:

    Special Super
    Units 100,000     30,200    
    Machine hours 49,500     39,000    
    Inspection hours 9,200     34,300    
    Rework hours 7,000     36,400    

    Harvey assigns overhead costs to the two products using a plantwide rate based on machine hours.

    Required:

    1. Calculate the unit overhead cost of the Special Model using machine hours to assign overhead costs. Round intermediate calculations and your final answer to the nearest cent, if rounding is required.
    $fill in the blank 1 per unit

    Now, repeat the calculation using ABC to assign overhead costs. Round intermediate calculations and your final answer to the nearest cent, if rounding is required.
    $fill in the blank 2 per unit

    Did improving the accuracy of cost assignments solve Harvey’s competitive problem?

    2. Now, assume that in addition to improving the accuracy of cost assignments, Earl observes that defective supplier components are the root cause of both the inspection and rework activities. Suppose further that Harvey has found a new supplier that provides higher-quality components such that inspection and rework costs are reduced by 50 percent. Now, calculate the cost of the Special Model (assuming that inspection and rework times are also reduced by 50 percent) using ABC. The relative consumption patterns also remain the same. Round intermediate calculations and your final answer to the nearest cent, if rounding is required.
    $fill in the blank 4 per unit

    Comment on the difference between ABC and ABM.

In: Accounting