Questions
Ingles Corporation is a manufacturer of tables. The table tops are manufactured by Ingles, but the...

Ingles Corporation is a manufacturer of tables. The table tops are manufactured by Ingles, but the table legs are purchased from an outside supplier. The Assembly Department takes a manufactured table top and attaches the four purchased table legs. It takes 16 minutes of labor to assemble a table. The company follows a policy of producing enough tables to ensure that 40 percent of next month’s sales are in the current month’s finished goods inventory. Ingles also purchases sufficient materials to ensure that the current month’s ending materials inventory is 60 percent of the following month’s direct materials required for production. Ingle’s sales budget in units for the next quarter is as follows:

July........................................................................................................ 2,450

August.................................................................................................. 2,900

September............................................................................................. 2,100

Ingle’s ending inventories in units for July 31 are as follows:

Finished goods...................................................................................... 1,900

Materials (legs)...................................................................................... 4,000

Requirements:

Prepare Ingle’s production budget for tables in August.

Prepare Ingle’s August direct materials purchases budget for table legs.

How many employees will be required for the Assembly Department in August?Fractional employees are acceptable since employees can be hired on a part-time basis.Assume a 40-hour week and a 4-week month.

In: Accounting

Required information Problem 14-23 Preparing a master budget for retail company with no beginning account balances...

Required information

Problem 14-23 Preparing a master budget for retail company with no beginning account balances LO 14-2, 14-3, 14-4, 14-5, 14-6

[The following information applies to the questions displayed below.]

Munoz Company is a retail company that specializes in selling outdoor camping equipment. The company is considering opening a new store on October 1, 2019. The company president formed a planning committee to prepare a master budget for the first three months of operation. As budget coordinator, you have been assigned the following tasks:

Problem 14-23 Part 1

Required

A. October sales are estimated to be $400,000, of which 45 percent will be cash and 55 percent will be credit. The company expects sales to increase at the rate of 20 percent per month. Prepare a sales budget.

B. The company expects to collect 100 percent of the accounts receivable generated by credit sales in the month following the sale. Prepare a schedule of cash receipts.

C. The cost of goods sold is 70 percent of sales. The company desires to maintain a minimum ending inventory equal to 20 percent of the next month’s cost of goods sold. However, ending inventory of December is expected to be $13,900. Assume that all purchases are made on account. Prepare an inventory purchases budget.

D. The company pays 80 percent of accounts payable in the month of purchase and the remaining 20 percent in the following month. Prepare a cash payments budget for inventory purchases.

E. Budgeted selling and administrative expenses per month follow:

Salary expense (fixed) $ 19,900
Sales commissions 4 % of Sales
Supplies expense 2 % of Sales
Utilities (fixed) $ 3,300
Depreciation on store fixtures (fixed)* $ 5,900
Rent (fixed) $ 6,700
Miscellaneous (fixed) $ 3,100

*The capital expenditures budget indicates that Munoz will spend $180,600 on October 1 for store fixtures, which are expected to have a $39,000 salvage value and a two-year (24-month) useful life.

Use this information to prepare a selling and administrative expenses budget.

F. Utilities and sales commissions are paid the month after they are incurred; all other expenses are paid in the month in which they are incurred. Prepare a cash payments budget for selling and administrative expenses.

G. Munoz borrows funds, in increments of $1,000, and repays them on the last day of the month. Repayments may be made in any amount available. The company also pays its vendors on the last day of the month. It pays interest of 2 percent per month in cash on the last day of the month. To be prudent, the company desires to maintain a $31,000 cash cushion. Prepare a cash budget.

Required A

October sales are estimated to be $400,000, of which 45 percent will be cash and 55 percent will be credit. The company expects sales to increase at the rate of 20 percent per month. Prepare a sales budget.

October November December
Sales Budget
Cash sales
Sales on account
Total budgeted sales

Required B

The company expects to collect 100 percent of the accounts receivable generated by credit sales in the month following the sale. Prepare a schedule of cash receipts.

October November December
Schedule of Cash Receipts
Current cash sales
Plus collections from A/R
Total collections

Required C

The cost of goods sold is 70 percent of sales. The company desires to maintain a minimum ending inventory equal to 20 percent of the next month’s cost of goods sold. However, ending inventory of December is expected to be $13,900. Assume that all purchases are made on account. Prepare an inventory purchases budget.

October November December
Inventory Purchases Budget
Inventory needed
Required purchases (on account)

Required D

The company pays 80 percent of accounts payable in the month of purchase and the remaining 20 percent in the following month. Prepare a cash payments budget for inventory purchases. (Round your final answers to the nearest whole dollar amounts.)

October November December
Schedule of Cash Payments Budget for Inventory Purchases
Payment of current month's accounts payable
Payment for prior month's accounts payable
Total budgeted payments for inventory

Required E

Prepare a selling and administrative expenses budget.

October November December
Selling and Administrative Expense Budget
Salary expense
Sales commissions
Supplies expense
Utilities
Depreciation on store fixtures
Rent
Miscellaneous
Total S&A expenses

Required F

Utilities and sales commissions are paid the month after they are incurred; all other expenses are paid in the month in which they are incurred. Prepare a cash payments budget for selling and administrative expenses.

October November December
Schedule of Cash Payments for S&A Expenses
Salary expense
Sales commissions
Supplies expense
Utilities
Depreciation on store fixtures
Rent
Miscellaneous
Total payments for S&A expenses

Required G

Munoz borrows funds, in increments of $1,000, and repays them on the last day of the month. Repayments may be made in any amount available. The company also pays its vendors on the last day of the month. It pays interest of 2 percent per month in cash on the last day of the month. To be prudent, the company desires to maintain a $31,000 cash cushion. Prepare a cash budget. (Any repayments/shortage which should be indicated with a minus sign.)

Show less

Cash Budget
October November December

Add: Cash receipts or Less: Cash receipts?

Cash available
Less: Payments
Total budgeted payments
Payments minus receipts
Financing activity

Beginning cash balance

Borrowing (repayment)

Ending cash balance

Financing activity

For inventory purchases

For selling and administrative expenses

Interest expense

Purchase of store fixtures

Surplus (shortage)

Add: Cash receipts

Less: Cash receipts

Part 2

Problem 14-23 Part 2

Prepare a pro forma income statement for the quarter.

Prepare a pro forma balance sheet at the end of the quarter.

Prepare a pro forma statement of cash flows for the quarter.

Required H

Required I

Required J

Prepare a pro forma income statement for the quarter.

MUNOZ COMPANY
Pro Forma Income Statement
For the Quarter Ended December 31, 2019

Cost of goods sold

Interest expense

Rent expense

Sales revenue

Selling and administrative expenses

Cost of goods sold

Interest expense

Rent expense

Sales revenue

Selling and administrative expenses

Gross margin

Gross loss

0

Cost of goods sold

Interest expense

Rent expense

Sales revenue

Selling and administrative expenses

Operating income

Operating loss

0

Cost of goods sold

Interest expense

Rent expense

Sales revenue

Selling and administrative expenses

Net income

Net loss

$0

Prepare a pro forma balance sheet at the end of the quarter. (Amounts to be deducted should be indicated by a minus sign.)

MUNOZ COMPANY
Pro Forma Balance Sheet
December 31, 2019
Assets 0 0

Accounts payable

Accounts receivable

Book value of fixtures

Cash

0
0
0

Add: Accumulated depreciation

Less: Accumulated depreciation

Accounts payable

Accounts receivable

Book value of fixtures

Cash

Inventory

Line of credit liability

Retained earnings

Sales commissions payable

Store fixtures

Utilities payable

0
Total assets $0
Liabilities

Accounts payable

Accounts receivable

Book value of fixtures

Cash

Inventory

Line of credit liability

Retained earnings

Sales commissions payable

Store fixtures

Utilities payable

Equity

Accounts payable

Accounts receivable

Book value of fixtures

Cash

Inventory

Line of credit liability

Retained earnings

Sales commissions payable

Store fixtures

Utilities payable

Total liabilities and equity $0

Prepare a pro forma statement of cash flows for the quarter. (Amounts to be deducted should be indicated by a minus sign.)

MUNOZ COMPANY
Pro Forma Statement of Cash Flows
For the Quarter Ended December 31, 2019
Cash flows from operating activities

Cash payment for store fixtures

Cash payments for selling and administrative expenses

Cash payments for interest expense

Cash payments for inventory

Cash payments for rent

Cash receipts from customers

Ending cash balance

Net inflow from line of credit

Net cash flows from operating activities $0
Cash flows from investing activities

Cash payment for store fixtures

Cash payments for selling and administrative expenses

Cash payments for interest expense

Cash payments for inventory

Cash payments for rent

Cash receipts from customers

Ending cash balance

Net inflow from line of credit

Cash flow from financing activities

Cash payment for store fixtures

Cash payments for selling and administrative expenses

Cash payments for interest expense

Cash payments for inventory

Cash payments for rent

Cash receipts from customers

Ending cash balance

Net inflow from line of credit

Net increase in cash

Net decrease in cash

Plus: Beginning cash balance

Less: Beginning cash balance

Cash payment for store fixtures

Cash payments for selling and administrative expenses

Cash payments for interest expense

Cash payments for inventory

Cash payments for rent

Cash receipts from customers

Ending cash balance

Net inflow from line of credit

$0

In: Accounting

How do consumption and investment spending affect aggregate expenditures and output over the business cycle? Which...

  1. How do consumption and investment spending affect aggregate expenditures and output over the business cycle?
  2. Which is more responsible for volatility - consumption or investment spending or both? Explain your choice.
  3. How do government actions affect consumption and investment?

300 word response

In: Economics

A decline in the interest rate is unlikely to have no effect on GDP? Agree or...

  1. A decline in the interest rate is unlikely to have no effect on GDP? Agree or disagree? Why?
  2. “Households tend to increase their spending during a recession because they realize that more spending will cause firms to hire more workers and the problem of unemployment will be solved.” Do you agree or disagree? Explain.

In: Economics

Most mammalian cell types do not undergo homologous recombination (HR), and even mouse ES cells do...

Most mammalian cell types do not undergo homologous recombination (HR), and even mouse ES cells do so at low frequency - about 1/200000 cells. However, if you first introduce a crRNA designed to target a mouse genomic sequence next to a PAM site, plus a source of Cas9 protein and a plasmid with homology arms, most mouse cell types will undergo HR with very high frequency -as high as 1/5 or more of the treated cells. What does this tell you about the mechanism of HR in mammalian cells?

A) The critical first step in HR is introduction of a double strand break at the target gene site.
B) Mouse ES cells have DNA repair systems that are defective compared to other cell types.
C) Cas9 protein directly activates expression of HR system genes in mammalian cells.
D) Mouse ES cells contain a larger number of PAM sites than most cell types.
E) Mouse ES cells already express higher levels of Cas9 than most cell types.

In: Biology

3. Asset management ratios Asset management ratios are used to measure how effectively a firm manages...

3. Asset management ratios

Asset management ratios are used to measure how effectively a firm manages its assets.

Remember, there are two slightly different equations that can be used to evaluate the management of a firm’s inventory. In either case, the inventory management ratio puts the inventory balance in the denominator and either its corresponding Sales value or the corresponding Cost of Goods Sold (COGS) value in the numerator. In the first (older) sales-based computation, the ratio identifies the number of sales dollars generated with each dollar of inventory held. The second, newer equation—which places COGS in the numerator—compares the costs of producing the firm’s goods with the amount of inventory held. Don’t forget that the components of COGS are direct materials, direct labor, and the overhead associated with producing the firm’s goods and services. Therefore, the COGS-based version of the ratio compares the firm’s inventory with its costs, whereas the Sales-based version compares the inventory balance with the firm’s revenues and profits.

Now, consider the following case:

Mall Toys Co. has a quick ratio of 2.00x, $37,575 in cash, $20,875 in accounts receivable, some inventory, total current assets of $83,500, and total current liabilities of $29,225. The company reported annual sales and cost of goods sold of $100,000 and $70,000, respectively, in the most recent annual report.

Over the past year, Mall Toys Co. sold and replace its ? x   times this year (using the sales-based inventory turnover ratio) and ? times per year (using the COGS-based ratio).

The sales-based inventory turnover ratio across companies in the industry is 4.39x. Based on this information, which of the following statements is true for Mall Toys Co.?

a.Mall Toys Co. is holding more inventory per dollar of sales compared to the industry average.

b.Mall Toys Co. is holding less inventory per dollar of sales compared to the industry average.

In: Finance

On October 31, the end of the first month of operations, Morristown & Co. prepared the...

On October 31, the end of the first month of operations, Morristown & Co. prepared the following income statement based on absorption costing:

Morristown & Co.
Absorption Costing Income Statement
For Month Ended October 31, 20--
Sales (2,600 units) $117,000
Cost of goods sold:
   Cost of goods manufactured $85,500
   Less ending inventory (400 units) 11,400
   Cost of goods sold 74,100
Gross profit $42,900
Selling and administrative expenses 21,500
Income from operations $21,400

If the fixed manufacturing costs were $42,900 and the variable selling and administrative expenses were $14,600, prepare an income statement using variable costing. Filling in the blanks with the following terms chart.

-Fixed manufacturing costs

-Less ending inventory

-Sales

-Variable cost of goods manufactured

-Wages Expense

-Fixed selling and administrative expenses

-Variable cost of goods sold

-Less ending inventory

-Utilities Expense

-Manufacturing margin

-Contribution margin

____________ $
Variable cost of goods sold:
____________ $
___________    $
___________    $
___________ $
___________    $
____________ $
Fixed costs:
____________ $
___________    $
Income from operations $

In: Accounting

Rieb Incorporated has provided the following data for the month of September. There were no beginning...

Rieb Incorporated has provided the following data for the month of September. There were no beginning inventories; consequently, the direct materials, direct labor, and manufacturing overhead applied listed below are all for the current month.

Work In Process Finished Goods Cost of Goods Sold Total
Direct materials $ 3,870 $ 8,950 $ 47,470 $ 60,290
Direct labor 10,030 24,280 130,210 164,520
Manufacturing overhead applied 6,920 12,110 67,470 86,500
Total $ 20,820 $ 45,340 $ 245,150 $ 311,310

Manufacturing overhead for the month was overapplied by $7,950.

The company allocates any underapplied or overapplied overhead among work in process, finished goods, and cost of goods sold at the end of the month on the basis of the overhead applied during the month in those accounts.

Required:

Provide the journal entry that would record the allocation of underapplied or overapplied among work in process, finished goods, and cost of goods sold. (If no entry is required for a transaction/event, select "No journal entry required" in the first account field.)

In: Accounting

1. In which situation does investment spending decrease? A.when the price level rises, causing interest rates...

1. In which situation does investment spending decrease?

A.when the price level rises, causing interest rates to fall

B.when the price level falls, causing interest rates to fall

C.when the price level rises, causing interest rates to rise

D.when the price level falls, causing interest rates to rise

2. If a central bank targets the interest rate, what does this imply?

A. The central bank must decrease the money supply if the interest rate is above its target.

B. The central bank can then set the money supply at whatever value it wants.

C. The central bank must increase the money supply if the interest rate is above its target.

D. The central bank must not change the money supply.

3. If households view a tax cut as being temporary, how does the tax cut affect aggregate demand?

A. It has the same effect on aggregate demand than if households view the cut as permanent.

B. It has no effect on aggregate demand.

C. It has a stronger effect on aggregate demand than if households view the cut as permanent.

D. It has a weaker effect on aggregate demand than if households view the cut as permanent.

4. What is the most important automatic stabilizer?

A. government spending

B. welfare benefits

C. the tax system

D. unemployment compensation

In: Economics

Carol’s Dress Shop produces high quality formal dresses. In January 2019 they produced 17,000 dresses. For...

Carol’s Dress Shop produces high quality formal dresses. In January 2019 they produced 17,000 dresses. For the month of January, the following standard and actual cost data are available. The normal monthly capacity of the company is 30,000 direct labor hours. All material purchased in January was used in January production.

Standard per Dress

Actual

Direct materials

5.0 yards @ $8.00 per yard

$660,000 for 80,000 yards

Direct labor

1.5 hours @ $15.00 per hour

$384,000 for 24,000 hours

Overhead

  1. hours @ $5.50 per hour

(fixed $3.40; variable $2.10)

$110,000 fixed overhead

$52,000 variable overhead

Overhead is applied on the basis of direct labor hours. At normal capacity, budgeted fixed overhead costs are $102,000 per month and budgeted variable overhead costs are $63,000 per month.

Required

  1. Calculate the variable overhead spending variance for January. Label the variance as favorable or unfavorable.
  2. Calculate the variable overhead efficiency variance for January. Label the variance as favorable or unfavorable.
  3. Calculate the fixed overhead spending variance for January. Label the variance as favorable or unfavorable.
  4. Calculate the fixed overhead production volume variance for January. Label the variance as favorable or unfavorable.
  5. Which of the variances should be investigated if management considers a variance of more than 5% from standard to be significant?
  6. Provide a discussion of the tradeoffs that are most likely to exist between the direct material and direct labor variances.

In: Finance