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...
-
An investment offers $7,000 per year for 15 years, with the first payment occurring I year from now. If the required return is 9 percent, what is the value of the investment? What would the value be...
-
Suppose that Jerry and Teddy are the only two sellers of designer umbrellas, which consumers view as differentiated products. For simplicity, assume each seller has a constant marginal cost equal to...
-
What went wrong with the evaluation meeting? Healthrus System had two goals for its annual employee performance evaluations: (1) to motivate employees to work hard and (2) to identify areas in which...
-
Each coffee table produced by Kevin Watson Designers nets the firm a profit of $ 9. Each bookcase yields a $ 12 profit. Watsons firm is small and its resources limited. During any given production...
-
One of your customers is delinquent on his accounts payable balance. Youve mutually agreed to a repayment schedule of $640 per month. You will charge 1.04 percent per month interest on the overdue...
-
A good friend or yours, Kelly Ford, has decided to leave his corporate job to launch a private Web marketing firm. He is putting together his business plan and asks you, Ive read several books and...
-
You manage the inventory for a car dealership. Data on current inventory can be found in the week 2 data set excel file. Management would like you to assess current inventory on the dealership lot....
-
Is the use of dual dating still relevant today given the requirements of obtaining sufficient, appropriate evidence?
-
Consider a portfolio constructed with a risky asset A and a risk-free asset. The portfolio has weight of w in asset A. Asset A has expected return of 12% and beta of 1.25; risk-free rate is 4%. What...
-
Which representation correctly uses curved arrows? + OCH + B OCH 3 H + Br B 3 + A + Bro B OCH 3 + :Br H OCH 3 + + Bro + Br
-
A large fast-food restaurant is having a promotional game where game pieces can be found on various products. Customers can win food or cash prizes. According to the company, the probability of...
-
Compute the Fixed Rate on a 10 year $100 million vanilla swap, where the cash flows are bond like, using the forward rate methodology and the spot rate approach. Assume annual compounding. Year 1 -...
-
Which function below has the following domain and range Domain 6 5 1 2 6 Range 2 3 8 6 2 5 3 1 8 2 5 6 9 2 3 5 2 1 8 6 3 6 2 O 2 5 8 1 3 6 2 6 3 2 O 6 6 2 8
-
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...
-
differentiate among the ethical models,
-
How do ethics and organizational mission and vision interrelate?
-
Prepare budgeted income statement (Learning Objective 2)} The budget committee of Vinning Office Supply has assembled the following data. As the business manager, you must prepare the budgeted income...
Study smarter with the SolutionInn App