Questions
DataSpan, Inc., automated its plant at the start of the current year and installed a flexible...

DataSpan, Inc., automated its plant at the start of the current year and installed a flexible manufacturing system. The company is also evaluating its suppliers and moving toward Lean Production. Many adjustment problems have been encountered, including problems relating to performance measurement. After much study, the company has decided to use the performance measures below, and it has gathered data relating to these measures for the first four months of operations.

Month
1 2 3 4
Throughput time (days) ? ? ? ?
Delivery cycle time (days) ? ? ? ?
Manufacturing cycle efficiency (MCE) ? ? ? ?
Percentage of on-time deliveries 82 % 77 % 74 % 71 %
Total sales (units) 2100 2010 1907 1835

Management has asked for your help in computing throughput time, delivery cycle time, and MCE. The following average times have been logged over the last four months:

Average per Month (in days)
1 2 3 4
Move time per unit 0.6 0.3 0.4 0.4
Process time per unit 2.3 2.2 2.1 2.0
Wait time per order before start of production 20.0 21.9 26.0 28.0
Queue time per unit 4.7 5.5 6.4 7.4
Inspection time per unit 0.8 1.1 1.1 0.8


Required:

1- Compute the throughput time for each month. Compute the delivery cycle time for each month. Compute the manufacturing cycle efficiency (MCE) for each month.

2. Evaluate the company’s performance over the last four months.

3-a. Refer to the move time, process time, and so forth, given for month 4. Assume that in month 5 the move time, process time, and so forth, are the same as in month 4, except that through the use of Lean Production the company is able to completely eliminate the queue time during production. Compute the new throughput time and MCE.

3-b. Refer to the move time, process time, and so forth, given for month 4. Assume in month 6 that the move time, process time, and so forth, are again the same as in month 4, except that the company is able to completely eliminate both the queue time during production and the inspection time. Compute the new throughput time and MCE.

In: Accounting

The units of an item available for sale during the year were as follows: Jan. 1...

The units of an item available for sale during the year were as follows: Jan. 1 Inventory 20 units at $41 Feb. 17 Purchase 12 units at $42 Jul. 21 Purchase 11 units at $45 Nov. 23 Purchase 8 units at $47 There are 10 units of the item in the physical inventory at December 31. The periodic inventory system is used. Round average unit cost to one decimal and final answers to the nearest whole dollar, if required. a. Determine the inventory cost by the first-in, first-out method. $ b. Determine the inventory cost by the last-in, first-out method. $ c. Determine the inventory cost by the weighted average cost method. $

In: Accounting

Last year Minden Company introduced a new product and sold 25,200 units of it at a...

Last year Minden Company introduced a new product and sold 25,200 units of it at a price of $92 per unit. The product's variable expenses are $62 per unit and its fixed expenses are $838,500 per year.

Required:

1. What was this product's net operating income (loss) last year?

2. What is the product's break-even point in unit sales and dollar sales?

3. Assume the company has conducted a marketing study that estimates it can increase annual sales of this product by 5,000 units for each $2 reduction in its selling price. If the company will only consider price reductions in increments of $2 (e.g., $68, $66, etc.), what is the maximum annual profit that it can earn on this product? What sales volume and selling price per unit generate the maximum profit?

Assume the company has conducted a marketing study that estimates it can increase annual sales of this product by 5,000 units for each $2 reduction in its selling price. If the company will only consider price reductions in increments of $2 (e.g., $68, $66, etc.), what is the maximum annual profit that it can earn on this product? What sales volume and selling price per unit generate the maximum profit?

Show less

Maximum annual profit
Number of units
Selling price per unit

4. What would be the break-even point in unit sales and in dollar sales using the selling price that you determined in requirement 3?

Break-even point in units   
Break-even point in dollar sales

In: Accounting

Jesper Manufacturing is preparing its master budget for the first quarter of the upcoming year. The...

Jesper Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Jesper Manufacturing's operations:

Current Assets as of December 31 (prior year):

     Cash          

$4,460

     Accounts receivable, net

$52,000

     Inventory

$15,400

Property, plant, and equipment, net

$122,000

Accounts payable

$44,000

Common stock

$126,860

Retained earnings

$23,000

  1. Actual sales in December were $76,000. Selling price per unit is projected to remain stable at $9 per unit throughout the budget period. Sales for the first five months of the upcoming year are budgeted to be as follows:

January

$80,100

February

$89,100

March

$82,800

April

$85,500

May

$77,400

  1. Sales are 30% cash and 70% credit. All credit sales are collected in the month following the sale.
  2. Jesper Manufacturing has a policy that states that each month's ending inventory of finished goods should be 10% of the following month's sales (in units).
  3. Of each month's direct material purchases, 20% are paid for in the month of purchase, while the remainder is paid for in the month following purchase. Two kilograms of direct material is needed per unit at $1.40/kg. Ending inventory of direct materials should be 20% of next month's production needs.
  4. Monthly manufacturing conversion costs are $6,500 for factory rent, $2,900 for other fixed manufacturing expenses, and $1.40 per unit for variable manufacturing overhead. No depreciation is included in these figures. All expenses are paid in the month in which they are incurred.
  5. Computer equipment for the administrative offices will be purchased in the upcoming quarter. In January, Jesper Manufacturing will purchase equipment for $5,800 (cash), while February's cash expenditure will be $11,600 and March's cash expenditure will be $15,800.
  6. Operating expenses are budgeted to be $1.20 per unit sold plus fixed operating expenses of $1,400 per month. All operating expenses are paid in the month in which they are incurred.
  7. Depreciation on the building and equipment for the general and administrative offices is budgeted to be $5,600 for the entire quarter, which includes depreciation on new acquisitions.
  8. Jesper Manufacturing has a policy that the ending cash balance in each month must be at least $4,400. It has a line of credit with a local bank. The company can borrow in increments of $1,000 at the beginning of each month, up to a total outstanding loan balance of $130,000. The interest rate on these loans is 1% per month simple interest (not compounded). Jesper Manufacturing pays down on the line of credit balance if it has excess funds at the end of the quarter. The company also pays the accumulated interest at the end of the quarter on the funds borrowed during the quarter.
  9. The company's income tax rate is projected to be 30% of operating income less interest expense. The company pays $10,800 cash at the end of February in estimated taxes.

Requirements:

  1. Prepare a schedule of cash collections for January, February, and March, and for the quarter in total.
  2. Prepare a production budget. (Hint: Unit sales = Sales in dollars / Selling price per unit.)
  3. Prepare a direct materials budget.
  4. Prepare a cash payments budget for the direct material purchases from Requirement 3.
  5. Prepare a cash payments budget for conversion costs.
  6. Prepare a cash payments budget for operating expenses.
  7. Prepare a combined cash budget.
  8. Calculate the budgeted manufacturing cost per unit. (Assume that fixed manufacturing overhead is budgeted to be $0.80 per unit for the year.)
  9. Prepare a budgeted income statement for the quarter ending March 31. (Hint: Cost of goods sold = Budgeted cost of manufacturing each unit x Number of units sold.)
  10. Prepare a partial budgeted balance sheet for March 31. Include Loans Payable and Income Tax Payable.
  11. Aside from depreciation, can you name another expense that is not payable in cash? (Hint: that expense is not listed in this problem).

In: Accounting

The nominal price (per pound) of apples for each year is shown in the timeline below....

The nominal price (per pound) of apples for each year is shown in the timeline below.

What is the real price of apples in year 2002 (as seen from year 2001).

Calculate your answer to the nearest penny (e.g., 3.81)

Year 2001 2002 2003 2004
Nominal Price $2.5 $2.54 $2.7 $2.8
Price Level 151 155 157 158
Price Adjustment
Real Price

In: Finance

QUESTION 11 Marc and Michelle are married and earned salaries this year of $68,000 and $15,000,...

QUESTION 11

  1. Marc and Michelle are married and earned salaries this year of $68,000 and $15,000, respectively. In addition to their salaries, they received interest of $350 from municipal bonds and $500 from corporate bonds. Marc contributed $3,000 to a qualified Individual Retirement Account, and Marc paid alimony to a prior spouse in the amount of $1,500 (2017 divorce).  Marc and Michelle have a 10-year-old son, Matthew, who lived with them throughout the entire year. Thus, Marc and Michelle are allowed to claim a $2,000 child tax credit for Matthew. Marc and Michelle paid $6,000 of expenditures that qualify as itemized deductions and they had a total of $3,500 in federal income taxes withheld from their paychecks during the course of the year. What is Marc and Michelle’s gross income?

QUESTION 12

  1. Same facts as Question 11 – What is Marc and Michelle’s adjusted gross income?

  

QUESTION 13

  1. Same facts as Question 11 – What is Marc and Michelle’s taxable income?

QUESTION 14

  1. Same facts as Question 11 – What is Marc and Michelle’s taxes payable or refund due?

In: Accounting

Company A and B can borrow for a 3-year term at the following rates. While A...

Company A and B can borrow for a 3-year term at the following rates. While A desires fixed rate borrowing, B prefers floating rate borrowing.

            Fixed Rate    Floating Rate

A         8.5%               LIBOR + 0.5%

B         7%                  LIBOR

The swap bank currently makes a market for plain vanilla 3-year interest rate swaps at 7.25% - 7.5%.

  1. Illustrate how Company A benefits from the use of interest rate swap.
  2. Summarize the risks taken by the swap bank in the interest swap with Company B.
  3. Is it feasible for the swap bank to customize an interest rate swap that provide a cost saving of 0.35% to B? Explain.
  4. Suppose both Company A and B entered into the 3-year swaps with the swap bank. One year after the inception of the 3-year swaps, the swap bank quotes 2-year interest rate swaps at 6.5% - 7%. Which company is willing to unwind the original swap? Explain how much it is willing to pay to unwind.

Please Complete ALL Parts!!!!

In: Finance

Danni is a single 30 percent owner of Kolt (a business entity). In the current year,...

Danni is a single 30 percent owner of Kolt (a business entity). In the current year, Kolt reported a $1,000,000 business loss. Answer the following questions associated with each of the following alternative scenarios: (Leave no answer blank. Enter zero if applicable.) Problem 15-55 Part a a. Kolt is organized as a C corporation and Danni works 20 hours a week as an employee for Kolt. Danni has a $200,000 basis in her Kolt stock. How much of Kolt’s loss is Danni allowed to deduct this year against her other income?

In: Accounting

Danni is a single 30 percent owner of Kolt (a business entity). In the current year,...

Danni is a single 30 percent owner of Kolt (a business entity). In the current year, Kolt reported a $1,000,000 business loss. Answer the following questions associated with each of the following alternative scenarios: (Leave no answer blank. Enter zero if applicable.) Problem 15-55 Part b b. Kolt is organized as an LLC taxed as a partnership. Thirty percent of Kolt’s loss is allocated to Danni. Danni works 20 hours a week on Kolt business activities (she is not considered to be a passive investor in Kolt). Danni has a $400,000 basis in her Kolt ownership interest and she also has a $400,000 at-risk amount in her investment in Kolt. Danni does not report income or loss from any other business activity investments. How much of the $300,000 loss allocated to her from Kolt is Danni allowed to deduct this year?

In: Accounting

Question 1. The following data is from the accounting records of Padcore Ltd. for the year...

Question 1.

The following data is from the accounting records of Padcore Ltd. for the year just ended:

Administrative expenses

           64,000

Administrative salaries

         110,000

Depreciation, factory

           25,000

Depreciation, office equipment

             8,000

Direct labour

         400,000

Factory equipment maintenance

           15,000

Factory supervisor's salary

           80,000

Insurance, factory

           22,000

Raw materials purchased

         260,000

Sales

     1,700,000

Sales salaries and commissions

         120,000

Selling expenses

           40,000

Supplies, factory

             9,000

Utilities, factory

           12,000

Beginning of

End of

the Year

the Year

Raw Materials

             20,000

             35,000

Work in process

             40,000

             30,000

Finished goods

             65,000

             40,000

Calculate the cost of goods manufactured, cost of goods sold and net income for the year just ended:


Question 2.

Waldorf Corporation had the following overhead costs for the previous year (Waldorf allocates overhead on the basis of direct labour hours):

Labour hours

Total Overhead

1st Quarter

                7,000

$              75,000

2nd Quarter

                6,000

$              74,000

3rd Quarter

                8,000

$              77,000

4th Quarter

                7,500

$              76,000

Assume that total overhead is comprised of Indirect materials (a variable cost), Rent (a fixed cost) and Maintenance (a mixed cost).  The breakdown of these three costs at the 6,000 labour hour level is as follows:

Indirect materials (V)

$                3,600

Rent (F)

                35,000

Maintenance (M)

                35,400

$              74,000

Determine how much of the total overhead at the 8,000 direct labour hour is maintenance.  Using the amount just determined and the high low method, estimate a cost formula for maintenance.  Determine what the cost formula for total overhead would be and estimate what total overhead costs would be at the 10,000 direct labour hour level.


Question 2A


Question 3.

The income statement for Big Franks Bicycle Emporium for the month just ended is as follows:

Sales

               300,000

Cost of goods sold

               140,000

Gross margin

               160,000

Less operating expenses

Selling expenses

             40,000

Depreciation

             25,000

Admin expenses

             65,000

Total operating expenses

               130,000

Net income

                 30,000

Additional information:

·       On average Frank sells his bikes for $300 each

·       The sales department has variable expenses of $12 per bike sold

·       Depreciation expense is unaffected by changes in the sales level

·       Admin costs are 70% fixed and 30% variable

Prepare an income statement for the month just ended using the contribution margin approach.


Question 4.

Wyatt Enterprises manufactures and sells a single product.  The company’s sales and expenses for the month just ended are as follows:

Total

Per Unit

Sales

$            190,000

$                      50

Less variable expenses

              114,000

                        30

Contribution margin

                76,000

$                      20

less fixed expenses

                60,000

Net income

$              16,000

Determine the break-even point in terms of both units and dollars.  How many units would need to be sold in a month to achieve a target profit of $25,000?  What is Wyatt’s margin of safety in both dollars and as a percentage?


Question 5.

The Happy Cardiologist Ltd. manufactures and sells pacemakers for $3,400 each.  Cost information for March was as follows:

Variable manufacturing costs per unit

$                   1,650

Variable selling costs per unit

                       150

Fixed manufacturing costs

                290,000

Fixed admin costs

                825,000

In March, the company sold 750 pacemakers.

Calculate the margin of safety in both dollars and as a percentage.  Compute the company’s degree of operating leverage.  If sales increase by 20%, by how much will net income increase?

In: Accounting