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...
-
Engineering Wonders reports net income of $60 million. Included in that number is building depreciation expense of $5 million and a gain on the sale of land of $1 million. Records reveal decreases in...
-
Describe a personal experience, or a situation you read about in the news in which too much empowerment was used.
-
Alternatives 1, 2, and 3 have lives of 3, 4, and 6 years, respectively. Their net cash flow (NCF) and salvage value (SV) profiles are as follows: Additional explanation is necessary: The NCF profile...
-
On January 1, 2014, Derek Company had Accounts Receivable $139,000, Notes Receivable $30,000, and Allowance for Doubtful Accounts $13,200. The note receivable is from Kaye Noonan Company. It is a...
-
Define a set X of strings in the symbols 0 and 1 as follows. B. 0 and 1 are in X. R. If x and y are in X, so is xxyy. R2. If x and y are in X, so is xyx. Explain why the string 01001011 EX using the...
-
Butler, Inc., operates at capacity and makes wooden playground equipment. Although Butlers swing sets and play forts are a matching set, they are sold individually and so the sales mix is not 1:1....
-
To obtain an in-depth analysis and critique of a specific legal topic, a researcher should refer to: a. Restatements of the Law b. A legal encyclopedia c. A legal periodical d. A digest
-
) Jiaxing owes $11,850 payable 5 years from now. What alternative amount should their creditor be willing to accept today if the money can earn 5.8% compounded semi-annually?
-
An operating system is a program that manages the complete operation of your computer or mobile device and lets you interact with it. a. True b. False
-
Suppose Wildhorse Company uses a periodic inventory system. Details related to inventory for the month of January are as follows: Units Unit Cost Total Balance, 1/1 280 $5.00 $1400 Purchase, 1/15 140...
-
The IASB and FASB have worked together to develop a single set of high-quality, understandable, enforceable and globally accepted international financial reporting standards. True or False
-
Getting Started Consulting began operations on January 1 , 2 0 2 4 , as a sole proprietorship. During the first month of operations, the business conducted the following transactions. 1 . The owner,...
-
The theoretical development of the residual income model relies on the clean surplus relation, or that all changes in book value are caused by either current earnings that are retained in the firm or...
-
Use translations to graph f. f(x) = x-/2 +1
-
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...
-
Are there any potential problems with devoting most compensation dollars to rewarding top performers, even if this means neglecting investments to improve the welfare of all employees (such as day...
-
In examples of profit-sharing with employees, once the total pool is established, the business needs to develop a methodology for providing individual rewards that are clear, logical, and fair. If...
-
Class is divided into two groups. One group must defend and support the awarding of bonuses on the basis of annual financial targets. The second group needs to support a more complex range of goals,...
Study smarter with the SolutionInn App