Complete the following project while following instructions and guidelines with detail.
Bob’s Bottling is a juice bottler. Bob’s produces bottled orange juice from fruit concentrate purchased from suppliers in Florida, Arizona, and California. The only ingredient in the juice is the concentrate provided by the supplier. The juice is processed, pasteurized, and bottled for sale in 16 ounce plastic bottles that are provided by each supplier with their own labels already attached.
Bob’s expects sales volume to be 250,000 units in the first quarter, with 25,000 unit increases in each succeeding quarter. Bob’s believes that sales will continue to increase in this nature into the first quarter of next year. Bob’s can sell each bottle of orange juice for $2.50 per bottle.
Bob’s believes it can meet future sales requirements by maintaining an ending inventory equal to 10% of the next quarter's budgeted sales volume.
Bob’s Bottling must use concentrate in order to make its juice. Bob’s has determined that it takes one gallon of concentrate for every 5 bottles of finished product (1/5 of a gallon, or .20 of a gallon). Each supplier provides Bob’s with a gallon of concentrate and the 5 plastic bottles needed for each gallon at a total unit price of $2.00. Bob’s requires 10% of next quarter’s raw material needs to be on hand at the end of the budget period.
Bob’s Bottling is highly automated. A worker can process 100 bottles of orange juice in one hour (1/100). Bob’s factory worker costs per employee average of $40 per hour.
Bob’s has the following manufacturing overhead costs:
Total variable overhead costs per unit = $0.40, (40 cents).
Total fixed overhead costs per quarter = $72,500 per quarter.
Bob’s has both variable and fixed expenses in selling their juices consisting of:
Variable selling expenses are 5% of sales revenues
Fixed Administrative Expenses = $10,000
Bob’s cash sales make up 25% of Sales Revenues. The other 75% of revenues are Sales on Credit.
• 80% of credit sales are collected in the quarter of the sale.
• 20% of credit sales are collected in the quarter following the sale.
• 20% Accounts Receivable carried forward to quarter 1 from last year’s sales is $75,000.
Bob’s cash payments are forecast to include the following;
• 75% of Raw Materials are paid for in the quarter purchased.
• 25% of Raw Materials are paid for in the quarter following the purchase.
• 25% of Accounts Payable carried forward to quarter 1 from last year’s purchases = $23,000.
• Manufacturing overhead included $5, 000 Depreciation Expense per quarter.
• All other expenses are paid in cash during the quarter incurred.
• Management plans to invest in new equipment in the first quarter that has a total cost of $250,000. Bob’s will pay 80% of the purchase price in cash during the first quarter, and then the remaining 20% in the second quarter.
Bob’s cash management includes the following;
• Cash on hand at the beginning of quarter 1 was $200,000. The minimum cash balance must remain at or above $200,000.
• Bob’s has an agreement with the bank allowing it to make short term borrowing and repayments of cash in $5,000 increments. No interest is charged if the loans are repaid by the end of the next quarter.
• Bob did not have any outstanding loans at the beginning of the 1st quarter.
Bob’s had the following balances of note at the end of the year
• Property Plant and Equipment (Net) = 750,000
• Common Stock = $800,000
• Note that this is a corporation, so the equity section of the balance sheet should include common stock and retained earnings.
Prepare the following budgets for the year broken into quarters.
• Sales budget
• Production budget
• Raw Materials Purchases Budget
• Direct Labor budget
• Manufacturing Overhead budget
• Budgeted Manufacturing Cost Per Unit
• Cost of Goods Sold Budget
• Selling and Administrative expense budget
• Budgeted Income Statement
• Budgeted Cash receipts
• Budgeted Cash Payments
• Cash Budget
• Budgeted Balance Sheet for the end of the year
• You must use Excel to do this project. All work must be in one Excel File. Multiple excel tabs may be used if the student desires, but only one file will be accepted.
• You are to show all calculations – either within the cell, beside the cell, and by linking excel formulas. Budgets should be presented in good form – to include similar formatting, $ where necessary, double underlines, etc.
• You are to work independently. If you need help, please ask the instructor in the Budget Project area of the discussion board in D2L.
We always make sure that writers follow all your instructions precisely. You can choose your academic level or professional level, and we will assign a writer who has a respective degree.
We have a team of professional writers with experience in academic and business writing. Many are native speakers and able to perform any task for which you need help.
If you think we missed something, send your order for a free revision. You have 10 days to submit the order for review after you have received the final document.
All papers are always delivered on time. In case we need more time to master your paper, we may contact you regarding the deadline extension.A 100% refund is guaranteed.
We use several writing tools checks to ensure that all documents you receive are free from plagiarism. Our editors carefully review all quotations in the text.
Tutorpro support agents are available 24 hours a day 7 days a week and committed to providing you with the best customer experience. Get in touch whenever you need any assistance.
Try it now!
How it works?
Follow these simple steps to get your paper done
Place your order
Fill in the order form and provide all details of your assignment.
Proceed with the payment
Choose the payment system that suits you most.
Receive the final file
Once your paper is ready, we will email it to you.
At Tutorpro, we have top rated masters and PhD writers who will help you tacke that homework and score A+ grade. Tutorpro services covers all levels of education : high school, college, university undergraduate, masters and PhD academic level.
No matter what kind of academic paper you need and how urgent you need it, you are welcome to choose your academic level and the type of your paper at an affordable price. We take care of all your paper needs and give a 24/7 customer care support system.
An admission essay is an essay or other written statement by a candidate, often a potential student enrolling in a college, university, or graduate school. You can be rest assurred that through our service we will write the best admission essay for you.
Tutorpro academic writers and editors make the necessary changes to your paper so that it is polished. We also format your document by correctly quoting the sources and creating reference lists in the formats APA, Harvard, MLA, Chicago / Turabian.
If you think your paper could be improved, you can request a review. In this case, your paper will be checked by the writer or assigned to an editor. This is free because we want you to be completely satisfied with the service offered.