Units to be sold Desired ending inventory Amount to be available Less: beginning inventory Units to...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Units to be sold Desired ending inventory Amount to be available Less: beginning inventory Units to be produced Production Budget July Aug Sep Quarter MASTER BUDGET GROUP WORK [Submit one copy per group on Canvas, write down the group members' names in the submitted file] : ABC Company makes one product and it provided the following information to help prepare the master budget for its first three months of operations: • The budgeted selling price per unit is $70. Budgeted unit sales for June, July, August, September, October, and November are 8,400, 10,000, 12,000, and 13,000 units, 14,000 units, and 15,000 units respectively. All sales are on credit. • 40% of credit sales are collected in the month of the sale and 60% in the following month. The ending finished goods inventory equals 20% of the following month's unit sales. • The ending raw materials inventory equals 10% of the following month's raw materials production needs. Each unit of finished goods requires 5 pounds of raw materials. The raw materials cost $2.00 per pound. • Thirty percent of raw materials purchases are paid for in the month of purchase and 70% in the following month. Accounts Payable balance on June 30 was $15,000. • The direct labor wage rate is $15 per hour. Each unit of finished goods requires two direct labor-hours. There is no guaranteed minimum wages. • Variable manufacturing overhead is $1.50 per direct labor hours. Fixed manufacturing overhead is $60,000 per month, which includes $10,000 depreciation expense. There is no noncash expense items other than depreciation expense. Total predetermined overhead rate (Variable and Fixed MOH combined) is calculated based on direct labor hours every quarter (round to the nearest dollar). • The variable selling and administrative expense per unit sold is $1.80. The fixed selling and administrative expense per month is $60,000, which includes $20,000 depreciation expense. There is no noncash expense items other than depreciation expense. For cash budget: 。 The company's beginning cash balance on July 1 was $38,000. The company requires a minimum cash balance of $100,000 and may borrow any amount needed from a local bank at an annual interest rate of 16% (therefore 4% quarterly). The company may borrow any amount at the beginning of any quarter and may repay its loans at the end of any quarter. Interest payments are due on any principal at the time it is repaid. 。 The company plans to pay dividends of $100,000 during July. Units to be sold Desired ending inventory Amount to be available Less: beginning inventory Units to be produced Production Budget July Aug Sep Quarter MASTER BUDGET GROUP WORK [Submit one copy per group on Canvas, write down the group members' names in the submitted file] : ABC Company makes one product and it provided the following information to help prepare the master budget for its first three months of operations: • The budgeted selling price per unit is $70. Budgeted unit sales for June, July, August, September, October, and November are 8,400, 10,000, 12,000, and 13,000 units, 14,000 units, and 15,000 units respectively. All sales are on credit. • 40% of credit sales are collected in the month of the sale and 60% in the following month. The ending finished goods inventory equals 20% of the following month's unit sales. • The ending raw materials inventory equals 10% of the following month's raw materials production needs. Each unit of finished goods requires 5 pounds of raw materials. The raw materials cost $2.00 per pound. • Thirty percent of raw materials purchases are paid for in the month of purchase and 70% in the following month. Accounts Payable balance on June 30 was $15,000. • The direct labor wage rate is $15 per hour. Each unit of finished goods requires two direct labor-hours. There is no guaranteed minimum wages. • Variable manufacturing overhead is $1.50 per direct labor hours. Fixed manufacturing overhead is $60,000 per month, which includes $10,000 depreciation expense. There is no noncash expense items other than depreciation expense. Total predetermined overhead rate (Variable and Fixed MOH combined) is calculated based on direct labor hours every quarter (round to the nearest dollar). • The variable selling and administrative expense per unit sold is $1.80. The fixed selling and administrative expense per month is $60,000, which includes $20,000 depreciation expense. There is no noncash expense items other than depreciation expense. For cash budget: 。 The company's beginning cash balance on July 1 was $38,000. The company requires a minimum cash balance of $100,000 and may borrow any amount needed from a local bank at an annual interest rate of 16% (therefore 4% quarterly). The company may borrow any amount at the beginning of any quarter and may repay its loans at the end of any quarter. Interest payments are due on any principal at the time it is repaid. 。 The company plans to pay dividends of $100,000 during July.
Expert Answer:
Answer rating: 100% (QA)
Answer MASTER BUDGET GROUP WORK Submit one copy per group on Canvas write down the group members names in the submitted file ABC Company makes one pro... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Damon Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Damon Manufacturing's operations: Current Assets as of December 31 (prior...
-
TBA, Inc., manufactures and sells concrete blocks for residential and commercial buildings. TBA expects to sell the following in 20x1: TBA expects the following unit sales and desired to end...
-
Osborne Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Osborne Manufacturings operations: Current assets as of December 31...
-
Research diversity expert Martin Davidson, author of The End of Diversity as We Know It: Why Diversity Efforts Fail and How Leveraging Difference Can Succeed. What is his direction for how you adopt...
-
Macrosoft Company reports net income of $65,000. The accounting records reveal depreciation expense of $80,000 as well as increases in prepaid rent, accounts payable, and income tax payable of...
-
Use the eighteen rules of inference to derive the conclusions of the following symbolized arguments. Do not use either conditional proof or indirect proof. 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 1. ()( D )...
-
Describe elements of religion, including sacred narrative, symbols and supernatural beings, states, and powers.
-
At the beginning of 2016, Copland Drugstore purchased a new computer system for $52,000. It is expected to have a five-year life and a $7,000 salvage value . Required a. Compute the depreciation for...
-
1. The diagram below shows numerical estimates of annual energy fluxes on Earth, in units of 108 terawatt-hours (TWh), where 1 TW = 10 W. For example, the "15.1" solar input number at the top means...
-
Read the case XYZ Company: An Integrated Capital Budgeting Instructional Case and answer the following question: Should the replacement asset be purchased? That is, does it make economic (financial)...
-
Q2 [20 pts] A delicate instrument of mass M2 = 10 kg contained in a box M = 5 kg is to be isolated from external sinusoidal vibration b(t) = 0.1sin20t m as illustrated in the figure. y2(t) m FW M2 K2...
-
How does budgeting help the management function of communication and coordination?
-
The standard cost of direct labour in the month of August is \( 36,000\). There is a direct labour rate variance of \( 6,000\) adverse and a direct labour efficiency variance of \( 2,500\)...
-
Explain how you would identify which variances to investigate.
-
How are direct labour rate and efficiency variances calculated?
-
Explain the purpose of long-range planning.
-
A 28-kg rock approaches the foot of a hill with a speed of 15m/s. This hill slopes upward at a constant angel of 40 degrees about horizontal. The coefficients of static and kinetic friction between...
-
Solve each equation or inequality. |6x8-4 = 0
-
Paint by Number prepares and packages paint products. Paint by Number has two departments: (1) Blending and (2) Packaging. Direct materials are added at the beginning of the blending process (dyes)...
-
Coco Bradley Sunglasses sell for about $150 per pair. Suppose the company incurs the following average costs per pair: Direct materials . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ....
-
Nautical Products, Inc., manufactures flotation vests in San Diego, California. Nautical Products' contribution margin income statement for the most recent month contains the following data: Sales in...
-
Who are the IASB and what is their role within the IFRS Foundation and standardsetting framework?
-
There are several advantages to incorporating your business, but can you list some of the commonly perceived disadvantages?
-
Define the three terms: asset; liability; and equity.
Study smarter with the SolutionInn App