Question

In: Accounting

The following annual budget data relates to Navient Inc. for the year ending December 31, 2018....

The following annual budget data relates to Navient Inc. for the year ending December 31, 2018.

                                       

Item

APP

Item

ZAP

Sales budget:

Anticipated volume in units

400,000

250,000

Unit selling price

$23.00

$29.00

Production budget:

Desired ending finished goods units

27,000

20,000

Beginning finished goods units

34,000

11,000

Direct materials budget:

Direct materials per unit (pounds)

3

4

Desired ending direct materials pounds

35,000

16,000

Beginning direct materials pounds

43,000

12,000

Cost per pound

$4.00

$5.00

Direct labor budget:

Direct labor time per unit

0.4

0.6

Direct labor rate per hour

$14.00

$14.00

Budgeted income statement:

Total unit cost

$14.00

$22.00

A detailed selling and administrative expense budget shows selling expenses of $660,000 for product APP and $360,000 for product ZAP, and administrative expenses of $545,000 for product APP and $344,000 for product ZAP. Income taxes are expected to be 25%.

Instructions

Prepare the following budgets for the year. Show data for each product. .

(a) Sales

(b) Production

(c) Direct materials

(d) Direct labor

(e) Income statement (Note: Income taxes are not allocated to the products.)

Solutions

Expert Solution

Answer 1

NAVIENT INC.

Sales budget

For the year ending December 31, 2018

Item APP

Item ZAP

Sales units

400000

250000

Price per unit

23

29

Total sales

9200000 units

7250000 units

Answer 2

NAVIENT INC.

Production budget

For the year ending December 31, 2018

Item APP

Item ZAP

Budgeted sales units

400000

250000

Add: ending finish unit

27000

20000

427000

270000

Less: beginning finish units

34000

11000

Planned Production in Units

393000 units

259000 units

Answer 3

NAVIENT INC.

Direct material budget

For the year ending December 31, 2018

Item APP

Item ZAP

Budgeted Production in Units

400000

250000

DM Required per Unit

3

4

DM Required of Production

1200000

1000000

Add: Budgeted Ending DM

35000

16000

1235000

1016000

Less: Beginning Direct Material

43000

12000

Budgeted DM Purchases

1192000

1004000

Cost per Pound

4

5

Budgeted DM Purchases in

$ 4768000

$ 5020000

Answer 4

NAVIENT INC.

Direct labor

For the year ending December 31, 2018

Item APP

Item ZAP

Planned Production in Units

393000

259000

Direct Labor Hours per Unit

0.4

0.6

Budgeted Direct Labor Hours

157200

155400

Cost per Direct Labor Hour

14

14

Budgeted Direct Labor Cost

$ 2200800

$ 2175600

As per our policy, we cannot able to post solution more than four sub part of question.


Related Solutions

The following annual budget data relates to Navient Inc. for the year ending December 31, 2018....
The following annual budget data relates to Navient Inc. for the year ending December 31, 2018.                                         Item APP Item ZAP Sales budget: Anticipated volume in units 400,000 250,000 Unit selling price $23.00 $29.00 Production budget: Desired ending finished goods units 27,000 20,000 Beginning finished goods units 34,000 11,000 Direct materials budget: Direct materials per unit (pounds) 3 4 Desired ending direct materials pounds 35,000 16,000 Beginning direct materials pounds 43,000 12,000 Cost per pound $4.00 $5.00 Direct labor budget:...
The following data relates to Rogers Company for the year ending December 31, 2020: Net Income...
The following data relates to Rogers Company for the year ending December 31, 2020: Net Income for 2020= $920,000 Preferred Stock= 10,000 shares of $100 par 8% cumulative preferred stock were outstanding throughout the year. The preferred stock is non-convertible Common Stock= 300,000 shares of common stock were issued and outstanding throughout the year. No shares were issued or repurchased, and there were no stock splits or dividends. Convertible Bonds= 12% convertible bonds at $4,000,000 face amount. (These bonds were...
Port Inc. is preparing its annual budgets for the year ending December 31, 2018. Accounting assistants...
Port Inc. is preparing its annual budgets for the year ending December 31, 2018. Accounting assistants furnish the data shown below. Product A Product B Sales budget: Anticipated volume in units 300,000 400,000 Unit selling price $10 $15 Production budget: Desired ending finished goods units 20,000 10,000 Beginning finished goods units 15,000 5,000 Direct materials budget: Direct materials per unit (pounds) 4 2 Desired ending direct materials pounds 20,000 15,000 Beginning direct materials pounds 30,000 10,000 Cost per pound $2...
Data below for the year ended December 31, 2018, relates to Houdini Inc., which began operations...
Data below for the year ended December 31, 2018, relates to Houdini Inc., which began operations on January 1, 2018. The retail price index at the end of 2018 was 1.10. Cost Retail Beginning inventory $ 66,000 $ 104,000 Net purchases 280,000 420,000 Net markups 20,000 Net markdowns 40,000 Net sales 375,000 Required: Calculate estimated ending inventory at cost assuming Houdini uses the Dollar-Value LIFO retail method.
Following are the data for Larson Co. for the year ending December 31 Year 2, and...
Following are the data for Larson Co. for the year ending December 31 Year 2, and the preceding year ended December 31 Year 1 and the indirect method of reporting cash flows from operating activities. In addition to the balance sheet data, assume that: Equipment costing $125,000 was purchased for cash. Equipment costing $85,000 with accumulated depreciation of $65,000 was sold for $15,000. The stock was issued for cash. The only entries in the retained earnings account were net income...
The following information relates to Joachim Anderson, Realtor, at the close of the fiscal year ending December 31:
The following information relates to Joachim Anderson, Realtor, at the close of the fiscal year ending December 31: 1. Joachim paid the local newspaper $300 for an advertisement to be run in January of the next year, and charged it to Advertising Expense.2. On November 1, Joachim signed a three-month, 10% note to borrow $12,000 from Yorkville Bank.3. The following salaries and wages are due and unpaid at December 31: sales, $1,300; office clerks, $1,000.4. Interest of $400 has accrued...
On the basis of the following data for Larson Co. for the year ending December 31...
On the basis of the following data for Larson Co. for the year ending December 31 Year 2, and the preceding year ended December 31 Year 1, prepare a statement of cash flows. Use the indirect method of reporting cash flows from operating activities. In addition to the balance sheet data, assume that: (Q.10) Equipment costing $125,000 was purchased for cash. Equipment costing $85,000 with accumulated depreciation of $65,000 was sold for $15,000. The stock was issued for cash. The...
The following information relates to Husk Corn Co. for the year ended December 31, 2018: The...
The following information relates to Husk Corn Co. for the year ended December 31, 2018: The company tells you that Income from Continuing Operations PRE Taxes is $ 300,000. However, this amount was computed before the company considered these items: (i.e. none of the items listed below are factored into the $300,000) Restructuring Costs incurred in 2018 were $25,000 When recording depreciation expense for the previous year (2017), they mistakenly recorded depreciation twice for the same asset. The amount of...
The following information relates to Husk Corn Co. for the year ended December 31, 2018: The...
The following information relates to Husk Corn Co. for the year ended December 31, 2018: The company tells you that Income from Continuing Operations PRE Taxes is $ 300,000. However, this amount was computed before the company considered these items: (i.e. none of the items listed below are factored into the $300,000) Restructuring Costs incurred in 2018 were $25,000 When recording depreciation expense for the previous year (2017), they mistakenly recorded depreciation twice for the same asset. The amount of...
The following information is provided for X Corporation for the year ending December 31, 2018: Book...
The following information is provided for X Corporation for the year ending December 31, 2018: Book earnings before income taxes $6,000 Tax exempt interest income 600 Taxes on foreign income above the U.S. statutory rate 200 State income taxes (before Federal benefit) 500 Annual increase in warranty reserve 200 Dividend received deduction on dividends from foreign subsidiaries 600 Foreign tax credits available after the TCJA 400 Tax over book depreciation for 2018 500 Current year increase in valuation allowance 1,000...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT