Albert Enterprises is a manufacturing company that builds heavy equipment repair

Albert Enterprises is a manufacturing company that builds heavy equipment repair parts for the construction industry. Albert is providing the following information for preparing their budgets for the first quarter of 2023.

• Sales: November, 2022 Actual Sales were $1,500,000 and December, 2022 Actual Sales were $2,100,000
• Budgeted Sales for the first 5 months of 2023 are:
o January 30,000 units
o February 40,000 units
o March 50,000 units
o April 45,000 units
o May 35,000 units
• Budgeted selling price is $60/unit
• All sales are made on the account. 30% is collected in the month of the sale, 50% is collected in the first month following the sale, and the remaining 20% is collected in the second month after the sale.
• The company wants to maintain a finished goods inventory equal to 40% of next month’s budgeted units of sales.
• Each unit of production requires 3kg of materials. The company maintains raw materials inventory equal to 20% of next month’s production needs. The budgeted purchase price for raw materials is $8/kg.
• All purchases of materials are made on account. 30% of the month’s purchases are paid in the month of purchase and the remaining 70% are paid the following month.
• Each unit of production requires 2 direct labor hours. The direct labor rate per hour is $6/hour and all labor costs are paid by the end of the month.
• Variable manufacturing overhead per direct labor hour is $2. The budgeted monthly fixed manufacturing overhead is $200,000 which includes monthly depreciation of $25,000.
• Variable selling expenses per unit sold are $2/unit. The budgeted monthly fixed selling and administrative expenses are $120,000 which includes monthly depreciation of $20,000.
• The company will be acquiring some additional equipment in the first quarter of the year. They will purchase equipment for $300,000 in cash in January.
• Dividends of $150,000 will be paid out in March.
• The company has a policy that it needs to maintain a cash balance of $50,000 at all times. They do have a line of credit with their bank. It has an annual interest rate of 12%. Borrowing, if needed, will occur at the beginning of the month and repayment of the principal and interest will occur at the end of the month. Borrowings and repayments are done in increments of $5,000.

1. Prepare the sales budget for each month of the first quarter. (25 points)
2. Prepare the schedule of expected cash collections for each month of the first quarter. (25 points)
3. Prepare the production budget for each month of the first quarter. (25 points)
4. Prepare the direct materials budget for each month of the first quarter. (25 points)
5. Prepare the schedule of cash payments to suppliers for each month of the first quarter. (25 points)
6. Prepare the direct labor budget for each month of the first quarter. (25 points)
7. Prepare the manufacturing overhead budget for each month of the first quarter. (25 points)
8. Prepare the selling and administrative expense budget for each month of the first quarter. (25 points)
9. Prepare the cash budget for each month of the first quarter. (50 points)
10. Prepare the budgeted income statement for the full quarter. (75 points)
11. Prepare the budgeted balance sheet as of March 31, 2023. (75 points)
Please read the following instructions carefully before you begin to attempt the project:
• Please complete each of the 10 budget templates for Albert Enterprises by month for the first quarter of the year (January, February, March 2023). The balance sheet will be as of March 31, 2023, and the Income Statement will be for the full quarter ended March 31, 2023.
• You will be utilizing the format and templates I had you work on during my video lecture. Please refer to the Module 2 PowerPoint presentation for guidance and format of each of the 10 budget schedules.
• You should prepare each schedule on a separate tab within Excel. If you create formulas as you build each template and link the schedules; it will allow you to make changes that will automatically update all schedules. This could be a tool you keep and use in your future companies.
• The learning outcome from this assignment is to give you the tools to complete a budget from start (Sales) to finish (financial statements).

Calculate the price of your order

Select your paper details and see how much our professional writing services will cost.

We`ll send you the first draft for approval by at
Price: $36
  • Freebies
  • Format
  • Formatting (MLA, APA, Chicago, custom, etc.)
  • Title page & bibliography
  • 24/7 customer support
  • Amendments to your paper when they are needed
  • Chat with your writer
  • 275 word/double-spaced page
  • 12 point Arial/Times New Roman
  • Double, single, and custom spacing
  • We care about originality

    Our custom human-written papers from top essay writers are always free from plagiarism.

  • We protect your privacy

    Your data and payment info stay secured every time you get our help from an essay writer.

  • You control your money

    Your money is safe with us. If your plans change, you can get it sent back to your card.

How it works

  1. 1
    You give us the details
    Complete a brief order form to tell us what kind of paper you need.
  2. 2
    We find you a top writer
    One of the best experts in your discipline starts working on your essay.
  3. 3
    You get the paper done
    Enjoy writing that meets your demands and high academic standards!

Samples from our advanced writers

Check out some essay pieces from our best essay writers before your place an order. They will help you better understand what our service can do for you.

  • Essay (any type)
    Direct Social Work Practice and Helping Process
    Undergrad. (yrs 3-4)
    Social Work and Human Services

Get your own paper from top experts

Order now

Perks of our essay writing service

We offer more than just hand-crafted papers customized for you. Here are more of our greatest perks.

  • Swift delivery
    Our writing service can deliver your short and urgent papers in just 4 hours!
  • Professional touch
    We find you a pro writer who knows all the ins and outs of your subject.
  • Easy order placing/tracking
    Create a new order and check on its progress at any time in your dashboard.
  • Help with any kind of paper
    Need a PhD thesis, research project, or a two-page essay? For you, we can do it all.
  • Experts in 80+ subjects
    Our pro writers can help you with anything, from nursing to business studies.
  • Calculations and code
    We also do math, write code, and solve problems in 30+ STEM disciplines.

Frequently asked questions

Get instant answers to the questions that students ask most often.

See full FAQ
  • How do you find the best essay writer for me?

    Our professional writing service focuses on giving you the right specialist so the one assigned will have the knowledge about the right topic. However, if you’ve used our essay service before, you can ask us to assign you the expert writer who used to complete papers for you in the past. We can easily do so if the specialist in question is available at the moment.

    If you’re ordering from our essay writing service for the first time, we will assign you a suitable expert ourselves and ensure that your academic essay writer is a pro. Moreover, let us know how complex your assignment is so that we can find the best match for your order.

    We’ve hired the best writers in 80+ academic subjects to complete any paper you need. As soon as we hear, “Write my essays,” our support team assigns you the writer who understands your needs and subject.

    In case you need to make sure we’ve picked a great specialist to deal with your paper, you can chat with the expert writers directly. We do our best to make sure you’re happy with the writer we’ve selected for you.

  • How can you prove that your paper writing service is not a scam?

    We have been selling original essays for more than 15 years. To prove that we are a trustworthy custom essay writing company, we provide quick delivery and a money-back guarantee. If we can’t complete your paper for any reason, we’ll send your money back to the credit card. We want to deliver the finest services, so you can decide if the paper is good enough; from our side, we’ll edit it according to your primary requirements to make the writing perfect. Our online paper writing service is about both giving you the materials you need when you need them and ensuring that your private data is safe. Check out our guarantees to see how we control the quality of your assignment and protect you as a customer.

See full FAQ

Take your studies to the next level with our experienced specialists