Please Prepare all components of MAKs master budget for the first quarter of the year. (Enter negative
Fantastic news! We've Found the answer you've been seeking!
Question:
Please Prepare all components of MAK’s master budget for the first quarter of the year. (Enter negative amounts using either a negative sign preceding the number e.g. -45. Do not leave any answer field blank. Enter 0 for amounts.)
Sales Budget
Selling and Administrative Expense Budget
Production Budget
Materials Purchases Budget
Direct Labor Budget
Manufacturing Overhead Budget
Ending Inventory and Cost of Goods Sold Budget
Cash Receipts Budget
Cash Payments for Inventory Budget
Cash Budget
Transcribed Image Text:
Mary Alice Kirkpatrick invented a process that converts liquid waste into a sweet-smelling candle that burns off the waste in an environmentally friendly way. MAK, as her friends call her, has turned that invention into a large-scale company and is now preparing the budget for the quarter ended March 31. She has gathered the following information. 1. 2. 3. 4. 5. 6. 7. 8. Brad Harmon, MAK's sales manager, reported that the company sold 60,000 candles in December. He has developed the following sales forecast. The expected sales price is $35 per candle. January 55,000 February 50,000 Total costs March April 45,000 46,000 Depreciation Salaries of sales personnel Advertising Management salaries All sales are made on account. Historically, the company has collected 75% of its sales in the month of sale and 20% in the month following the sale. The remaining 5% of sales are uncollectible. May 48,000 Sales personnel receive a 3% commission on every candle sold in addition to their monthly salaries. The following monthly fixed selling and administrative expenses are planned for the quarter. However, these amounts do not include the depreciation increase resulting from the budgeted equipment purchase in March (see part 8). Monthly Fixed Selling and Administrative Costs $5,000 33,255 12,000 24,000 $74,255 The company requires ending finished goods inventory to equal 15% of the following month's budgeted sales, in units. On December 31, 8,200 candles were on hand. Ten ounces of raw materials are required to create each finished candle. The company wants to have raw materials on hand at the end of each month equal to 20% of the following month's production needs. On December 31, 109,000 ounces of materials were on hand. The raw materials used in production cost $2.00 per ounce. Eighty percent of the month's purchases are paid for in the month of purchase; the rest is paid in the following month. No discount is available. The standard labor allowed for one candle is 18 minutes. The current direct labor rate is $16 per hour. On March 1, the company plans to spend $72,000 to replace its office equipment that is fully depreciated. The new equipment is expected to have a ten-year life, with no residual value. Mary Alice Kirkpatrick invented a process that converts liquid waste into a sweet-smelling candle that burns off the waste in an environmentally friendly way. MAK, as her friends call her, has turned that invention into a large-scale company and is now preparing the budget for the quarter ended March 31. She has gathered the following information. 1. 2. 3. 4. 5. 6. 7. 8. Brad Harmon, MAK's sales manager, reported that the company sold 60,000 candles in December. He has developed the following sales forecast. The expected sales price is $35 per candle. January 55,000 February 50,000 Total costs March April 45,000 46,000 Depreciation Salaries of sales personnel Advertising Management salaries All sales are made on account. Historically, the company has collected 75% of its sales in the month of sale and 20% in the month following the sale. The remaining 5% of sales are uncollectible. May 48,000 Sales personnel receive a 3% commission on every candle sold in addition to their monthly salaries. The following monthly fixed selling and administrative expenses are planned for the quarter. However, these amounts do not include the depreciation increase resulting from the budgeted equipment purchase in March (see part 8). Monthly Fixed Selling and Administrative Costs $5,000 33,255 12,000 24,000 $74,255 The company requires ending finished goods inventory to equal 15% of the following month's budgeted sales, in units. On December 31, 8,200 candles were on hand. Ten ounces of raw materials are required to create each finished candle. The company wants to have raw materials on hand at the end of each month equal to 20% of the following month's production needs. On December 31, 109,000 ounces of materials were on hand. The raw materials used in production cost $2.00 per ounce. Eighty percent of the month's purchases are paid for in the month of purchase; the rest is paid in the following month. No discount is available. The standard labor allowed for one candle is 18 minutes. The current direct labor rate is $16 per hour. On March 1, the company plans to spend $72,000 to replace its office equipment that is fully depreciated. The new equipment is expected to have a ten-year life, with no residual value.
Expert Answer:
Answer rating: 100% (QA)
Sales Budget Units Sales price Sales Cash receipts budget December AR January sales February sales M... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Dudley Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Dudley Manufacturing's operations: Current Assets as of December 31...
-
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...
-
Presidio Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Presidio Manufacturing's operations: Current assets as of December 31...
-
Shelby Company has an available production capacity of 180,000 hours. This can be used to produce 3 products in any combination. The total fixed cost is 180,000. Other information is as follows: X Y...
-
Examine Round Rocks assets. 1. What is Round Rocks largest category of assets? List all 2011 assets in the largest category and their amounts as reported by Round Rock. 2. What was Round Rocks cost...
-
Assume that Anthony had contacted various users of Yahoos online dating service only to discover that each users profile exaggerated the users physical appearance, intelligence, and occupation. Would...
-
What factors can you use to evaluate a savings plan?
-
Bill Johnson, sales manager, and Diane Buswell, controller, at Current Designs are beginning to analyze the cost considerations for one of the composite models of the kayak division. They have...
-
pleasehelp solve Bill Clinton reportedly was paid \( \$ 15.0 \) million to write his book My Life. The book took three years to write. In the time spent writing, Clinton could have been paid to make...
-
Shelby Shelving is a small company that manufactures two types of shelves for grocery stores. Model S is the standard model; model Lx is a heavy-duty version. Shelves are manufactured in three major...
-
(1 point) The graph of f(x) = 2x + 15x 84x + 20 has two horizontal tangents. One occurs at a negative value of x and the other at a positive value of x. What is the negative value of x where a...
-
The stock of Business Adventures sells for $40 a share. Its likely dividend payout and end-of-year price depend on the state of the economy by the end of the year as follows: Boom Normal economy...
-
Mammy is out of the kitchen and it's a great opportunity to get you hands on that cake inside the fridge. Alas, Daddy has the same idea and also rushes to the same end! Your Dad wishes to negotiate...
-
How does the psychologic and economic impact differ from other forms of terrorism such as cyber terrorism? Also, how does a client's prejudices and attitudes can pose a danger to the personal...
-
Consider an individual with an annual income of $50,000, who allocates this income as follows: $10,000 on leisure activities, $20,000 on dining out, and $20,000 on medical expenses. The income...
-
Assume a country's health care expenditures (HCE) are financed from two sources: (1) public expenditures (PE) and (2) out-pocket-payments (OOP). Thus HCE = PE + OOP. Given the following...
-
Explain Behavioral Learning Theory . What is the focus of this theory and how does this specific theory help you understand the client and their approach to the issue? Give an example of how this...
-
A city maintains a solid waste landfill that was 12 percent filled at the end of Year 1 and 26 percent filled at the end of Year 2. During those periods, the government estimated that total closure...
-
Indicate whether each of the following is characteristic of a lean production system or a traditional production system. a. A workplace organization system called 5S is frequently used to keep work...
-
FlashCo segments its company into four distinct divisions. The net revenues, operating profit, and total assets for these divisions are disclosed in the footnotes to FlashCos consolidated...
-
Eduardo Corporation has the following activities for the past year: Requirement Prepare the operating activities section of Eduardo Corporations statement of cash flows for the year ended December...
-
What are three sources of tax assistance?
-
What types of investments might you make for tax purposes?
-
Tax professionals can provide you with advice about how to minimize the amount of tax you have to pay and still pay a fair amount.
Study smarter with the SolutionInn App