Master Budget Based on the following information, prepare the Master Budget for Brindle Arts, Inc. for...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Master Budget Based on the following information, prepare the Master Budget for Brindle Arts, Inc. for Quarter 4, 2020 Beginning of quarter balances: Cash Accounts Receivable Finished Goods Inventory (pieces of art) Raw Materials inventory (kits) Buildings and equipment Accounts Payable Common Stock Retained Earnings Actual and budgeted sales data (pieces of art): October Sept. (act.) 3,250 Artwork is sold for $200 each. 3,000 Selling price per piece of situad $ November 3,500 200 $ $ $ $ $ 150,000 260,000 300 610 350,000 50,294 150,000 52,431 December 4,500 January 2,100 February 3,300 Sales are 60% for cash and 40% on credit. Credit sales are collected in the month following sale. The accounts receivable at the beginning of the quarter are a result of September's credit sales. Sales: Cash 60% Credit 40% The finished goods inventory on hand at the end of each month must equal 10% of the next month's sales. of next month's sales Finished Goods inventory 10% The raw materials inventory on hand at the end of each month must equal 10% of the following month's production needs for raw materials. Raw materials inventory: 10% of next month's production needs Rawm materials needed per unit of artwork Raw materials cost: $ 32.50 per finishing kit 75% of each raw materials purchases is paid for in the month of purchase; the other 25% is paid in the following month. The accounts payable at the beginning of the quarter are the result of September raw materials purchases. Purchases: Month of 75% Month after 25% Manufacturing and Selling and Administrative costs: Variable cost per unit: Direct $ matoriale Direct labor $ Var. MOH $ Var. S&A $ 65.00 30.00 15.00 10.00 Office equipment 5,000 2 finishing kits in October Fixed costs per month: Manufacturing OH Depreciation - Manuf. Selling and Admin. Depreciation - S&A Office equipment costing $5,000 will be purchased for cash in October and new equipment will be purchased in December for $8,000. Equipment purchase $ $ $ $ 170,000 180,000 125,000 75,000 8,000 in December Management would like to maintain a minimum cash balance of at least $50,000 at the end of each month. The company has an agreement with a local bank that allows the company to borrow in increments of $1,000 at the beginning of each month. The interest rate on these loans is 1% per month and for simplicity we will assume that interest is not compounded. The company would, as far as it is able, repay the loan plus accumulated interest at the end of the quarter. Minimum cash on hand $ Borrow in $ Interest (no compounding) Use the data above, complete the following statements and schedules for the Quarter 4, 2020: Schedule of expected cash collections: Cash Sales Credit sales Total cash collected Production budget Budgeted unit sales Add desired ending finished goods inventory Total needs Less beginning finished goods inventory Required production in units Direct materials budget Required production in units of finished goods (gift baskets) Units of raw materials needed to meet production (bags of snack mix) Add desired units of ending raw materials inventory (bags of snack mix) Total units of raw materials needed (bags of snack mix) 50,000 1.000 increments 1% October October October November November November December December December Quarter January Quarter Bonus (up to 2pts) January Accounts Receivable at the end of the quarter Units of raw materials to be purchased (bags of snack mix) Cost of raw materials to be purchased (bags of snack mix) Schedule of expected cash disbursements for inventory purchases: October September purchases October purchases November purchases December purchases Total cash disbursements for purchases Direct labor budget Cash Disbursed Required production, in units Total direct labor cost Cash budget Beginning Cash balance Add cash collections Total cash available Less total cash disbursements: Purchases Direct labor Variable manufacturing OH Fixed manufacturing OH October October November November November December December December Quarter Quarter Quarter Bonus (up to 2pts) Accounts Payable at the end of the quarter Variable S&A Fixed S&A Equipment Total cash disbursements Cash available before financing Financing: Borrowings (at beginnings of quarters) Repayments Interest Total Financing Ending Cash balance Prepare an absorption costing income statement for the quarter ending December 31. Sales revenue Less variable costs: Cost of goods sold Selling and admin. Total variable costs Contribution margin Less fixed costs: Manufacturing overhead Selling and admin. Total fixed costs Operating income Less interest expense Het income (loss) Brindle Arts,Inc. Income Statement For Quarter Ended December 31 Prepare a balance sheet as of December 31. Brindle Arts,Inc. Balance Sheet As of December 31 Assets Current Assets: Cash Accounts Receivable Inventory Total Current Assets Buildings and equipment - net Total Assets Liabilities and Stockholders' Equity Current Liabilities: Accounts Payable Stockholders' equity: Common Stock Retained Earnings Total Liabilities and Stockholders' Equity Bonus (up to 3pts) Master Budget Based on the following information, prepare the Master Budget for Brindle Arts, Inc. for Quarter 4, 2020 Beginning of quarter balances: Cash Accounts Receivable Finished Goods Inventory (pieces of art) Raw Materials inventory (kits) Buildings and equipment Accounts Payable Common Stock Retained Earnings Actual and budgeted sales data (pieces of art): October Sept. (act.) 3,250 Artwork is sold for $200 each. 3,000 Selling price per piece of situad $ November 3,500 200 $ $ $ $ $ 150,000 260,000 300 610 350,000 50,294 150,000 52,431 December 4,500 January 2,100 February 3,300 Sales are 60% for cash and 40% on credit. Credit sales are collected in the month following sale. The accounts receivable at the beginning of the quarter are a result of September's credit sales. Sales: Cash 60% Credit 40% The finished goods inventory on hand at the end of each month must equal 10% of the next month's sales. of next month's sales Finished Goods inventory 10% The raw materials inventory on hand at the end of each month must equal 10% of the following month's production needs for raw materials. Raw materials inventory: 10% of next month's production needs Rawm materials needed per unit of artwork Raw materials cost: $ 32.50 per finishing kit 75% of each raw materials purchases is paid for in the month of purchase; the other 25% is paid in the following month. The accounts payable at the beginning of the quarter are the result of September raw materials purchases. Purchases: Month of 75% Month after 25% Manufacturing and Selling and Administrative costs: Variable cost per unit: Direct $ matoriale Direct labor $ Var. MOH $ Var. S&A $ 65.00 30.00 15.00 10.00 Office equipment 5,000 2 finishing kits in October Fixed costs per month: Manufacturing OH Depreciation - Manuf. Selling and Admin. Depreciation - S&A Office equipment costing $5,000 will be purchased for cash in October and new equipment will be purchased in December for $8,000. Equipment purchase $ $ $ $ 170,000 180,000 125,000 75,000 8,000 in December Management would like to maintain a minimum cash balance of at least $50,000 at the end of each month. The company has an agreement with a local bank that allows the company to borrow in increments of $1,000 at the beginning of each month. The interest rate on these loans is 1% per month and for simplicity we will assume that interest is not compounded. The company would, as far as it is able, repay the loan plus accumulated interest at the end of the quarter. Minimum cash on hand $ Borrow in $ Interest (no compounding) Use the data above, complete the following statements and schedules for the Quarter 4, 2020: Schedule of expected cash collections: Cash Sales Credit sales Total cash collected Production budget Budgeted unit sales Add desired ending finished goods inventory Total needs Less beginning finished goods inventory Required production in units Direct materials budget Required production in units of finished goods (gift baskets) Units of raw materials needed to meet production (bags of snack mix) Add desired units of ending raw materials inventory (bags of snack mix) Total units of raw materials needed (bags of snack mix) 50,000 1.000 increments 1% October October October November November November December December December Quarter January Quarter Bonus (up to 2pts) January Accounts Receivable at the end of the quarter Units of raw materials to be purchased (bags of snack mix) Cost of raw materials to be purchased (bags of snack mix) Schedule of expected cash disbursements for inventory purchases: October September purchases October purchases November purchases December purchases Total cash disbursements for purchases Direct labor budget Cash Disbursed Required production, in units Total direct labor cost Cash budget Beginning Cash balance Add cash collections Total cash available Less total cash disbursements: Purchases Direct labor Variable manufacturing OH Fixed manufacturing OH October October November November November December December December Quarter Quarter Quarter Bonus (up to 2pts) Accounts Payable at the end of the quarter Variable S&A Fixed S&A Equipment Total cash disbursements Cash available before financing Financing: Borrowings (at beginnings of quarters) Repayments Interest Total Financing Ending Cash balance Prepare an absorption costing income statement for the quarter ending December 31. Sales revenue Less variable costs: Cost of goods sold Selling and admin. Total variable costs Contribution margin Less fixed costs: Manufacturing overhead Selling and admin. Total fixed costs Operating income Less interest expense Het income (loss) Brindle Arts,Inc. Income Statement For Quarter Ended December 31 Prepare a balance sheet as of December 31. Brindle Arts,Inc. Balance Sheet As of December 31 Assets Current Assets: Cash Accounts Receivable Inventory Total Current Assets Buildings and equipment - net Total Assets Liabilities and Stockholders' Equity Current Liabilities: Accounts Payable Stockholders' equity: Common Stock Retained Earnings Total Liabilities and Stockholders' Equity Bonus (up to 3pts)
Expert Answer:
Answer rating: 100% (QA)
To assist you further Ill need to go through each section stepbystep Since the question is large it would be helpful to focus on specific parts one at ... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Prepare the current asset section based on the following alphabetized post-closing trial balance information at March 31, 2014, for Whiteagle Company: Account Accounts payable Accounts receivable...
-
A binomial probability model is to be based on the following index function model: y* = ? + ?d + ?, y = 1, if y* > 0, y = 0 otherwise. The only regress or, d, is a dummy variable. The data consist of...
-
Based on the following accounts, calculate (a) Net sales, (b) Cost of goods sold, (c) Gross profit, (d) Net income. Accounts Payable .................. $ 6,400 Operating Expenses .....................
-
The common stock of Scarlet Enterprises currently pays a quarterly dividend of $1.75 per share. The dividend is assumed to grow annually at a constant rate of 4.0%. The market beta for Scarlet...
-
After Russia seized what had formerly been the Ukrainian territory of Crimea in February 2014, the United States and many other countries imposed economic sanctions that reduced the ability of Russia...
-
Two feeds containing methanol and water are sent to the same flash drum. Feed 1 is \(20 \mathrm{~mol} \%\) methanol, \(F_{1}=150 \mathrm{kmol} / \mathrm{h}\), and \((V / F)_{1}=0.4\). Feed 2 is \(30...
-
What are the challenges of international IT management? LO.1
-
The unadjusted trial balance of Canton Air Purification System at December 31, 2014, and the data needed for the adjustments follow. Adjustment data at December 31 follow: a. On December 15, Canton...
-
The income statement, balance sheets, and additional Information for Video Phones, Inc., are provided. $3,636,000 VIDEO PHONES, INC. Income Statement For the Year Ended December 31, 2021 Net sales...
-
A. Richard McCarthy (born 2/14/64; Social Security number 100-10-9090) and Christine McCarthy (born 6/1/1966; Social security number 101-21-3434) have a 19-year-old son (born 10/2/99 Social Security...
-
1. Can behaving dishonestly in the context of a contract, i.e. one party not being honest "in relation to the performance of their contractual obligations," become the cause of a breach of contract...
-
Describe in your own words how you would expect the data points on a scatterplot to be distributed if the following features were present (i.e. for each part, explain how the feature would look on a...
-
imagine this experimental setup: One temperature probe is in embedded in a small block of frozen sugar water at -20. The frozen sugar water is in a small test tube The melting/freezing point of this...
-
Question 2: (40 points: 10 each) During September, Sweet Foods manufactures a single product. The Company's material purchases amounted to 9,000 pounds at a price of $9.80 per pound. Actual costs...
-
E12-23 (Algo) (Supplement 12B) Preparing a Statement of Cash Flows, Indirect Method: T-Account Approach [LO 12-S2] Golf Goods Incorporated is a regional and online golf equipment retailer. The...
-
A symmetric compound channel in over bank flow has a main channel with a bottom width of 30 m, side slopes of 1:1, and a flow depth of 3m. The floodplains on either side of the main channel are both...
-
Which of the following organizations is currently responsible for setting U.S. accounting standards? The Accounting Principles Board (APB). The Committee on Accounting Procedure. The Financial...
-
What are multinational corporations (MNCs) and what economic roles do they play?
-
Linda Kipp started a business on May 1, 20--. Analyze the following transactions for the first month of business using T accounts. Label each T account with the title of the account affected and then...
-
Page 205 shows a work sheet for Megaffin's Repairs. No additional investments were made by the owner during the month. REQUIRED 1. Prepare an income statement. 2. Prepare a statement of owner's...
-
Dr. John Salvaggi is a chiropractor. As of December 31, he owned the following property that related to his professional practice. Cash ................ $ 3,500 Office Equipment .......... 6,400...
-
For model selection, should model evaluation be performed on the training data set or the test data set, and why?
-
Suppose our model has perfect sensitivity and perfect specificity. What then is our accuracy and overall error rate?
-
Explain in your own words what is meant by lift.
Study smarter with the SolutionInn App