A budgeted balance sheet as at June 30th 2012.

 Juicers Inc produces multiple fruit juices for the Caribbean market
. You have been given responsibility forall planning and budgeting
. The next operational planning meeting is two weeks away and they would likea master budget prepared for the next three months on the planning horizon
. The accounting department hasprovided the following information
.The company has a requirement that minimum cash balance of $40,000 each month
. The juices are sold at$8 per liter
. Recent forecast sales in units are as follows:January (actual) 80,000 June 240,000February (actual) 96,000 July 160,000March (actual) 112,000 August 144,000April 140,000 September 128,000May 180,000The large build up in sales before and up to the month of June is in preparation for the annual carnival
.Ending inventories are supposed to be 80% of the next month sales in units
. The juices cost $ 5
. per unit toproduce
.Purchases are paid for as follows, 50% in the month of purchase and the remaining 50% in the followingmonth
. All sales are on credit with no discounts
. The cash from the collection of sales is as follows, 25% iscollected in the month of sale, 50% one month later and the remaining 25% is collected 2 months after sale
.The other operating expenses are as follows:VariableSales commissions $1 per juiceFixedSalaries and wages $88,000Utilities 56,000Insurance expired 4,800Depreciation 6,000Miscellaneous 12,000All operating expenses are paid in the month in cash except depreciation and insurance expired
. Land ispurchased in May for $100,000
. The company pays dividends the first month of each quarter of $48,000which were declared in the last month of the previous quarter
. The unaudited balance sheet at the end of thelast quarter which ended March 31st 2012 is shown below
.2AssetsCash $ 56,000Accounts receivable ($192,000 of February sales,$672,000 of March sales)864,000Inventory (126,000 units) 630,000Unexpired Insurance 57,600Fixed Assets (net of depreciation) 690,800Total Assets $2,298,400Liabilities and Stockholders EquityAccounts payable purchases 343,000Dividend payable 48,000Capital stock 1,200,000Retained Earnings 707,400Total Liabilities and Stockers equity $2,298,400The company can borrow money at 12% per annum interest rate
. All borrowings must be at the beginningof the month and all repayments occur at the end of the month
. Borrowing and repayment of principal mustbe in increments of $1,000
.Prepare a master budget for the three months period ended June 30th 2012, including the following detailedbudgets:1
. a) Sales budget by month and in totalb) A schedule of expected sales collection from sales and accounts receivable by month and intotalc) A purchases budget in units and in dollars
. Show the budget by month and in total
.d) A schedule of budgeted cash disbursement for purchases by month and in total
. A cash budget
. Show the budget by month and in total
. A budgeted income statement for the three month period ended June 30th 2012
. Use thecontribution margin format
. A budgeted balance sheet as at June 30th 2012

Order a similar paper and get 15% discount on your first order with us

Dr. Padma Myers
Dr. Padma Myers
98% Success Rate
Read More
“Hello, I deliver nursing papers on time following instructions from the client. My primary goal is customer satisfaction. Welcome for plagiarism free papers”
Stern Frea
Stern Frea
98% Success Rate
Read More
Hi! I am an English Language and Literature graduate; I have written many academic essays, including argumentative essays, research papers, and literary analysis.
Dr. Ishid Elsa
Dr. Ishid Elsa
98% Success Rate
Read More
"Hi, count on me to deliver quality papers that meet your expectations. I write well researched papers in the fields of nursing and medicine".
Dr. Paul P. Klug
Dr. Paul P. Klug
99% Success Rate
Read More
"A top writer with proven reliability and experience. I have a 99% success rate, overall rating of 10. Hire me for quality custom written nursing papers. Thank you"

How Our Essay Writing Service Works

Tell Us Your Requirements

Fill out order details and instructions, then upload any files or additional materials if needed. Then, confirm your order by clicking “Place an Order.”

Make your payment

Your payment is processed by a secure system. We accept Mastercard, Visa, Amex, and Discover. We don’t share any informati.on with third parties

The Writing Process

You can communicate with your writer. Clarify or track order with our customer support team. Upload all the necessary files for the writer to use.

Download your paper

Check your paper on your client profile. If it meets your requirements, approve and download. If any changes are needed, request a revision to be done.

Recent Questions

Stay In Touch!

Leave your email and get discount promo codes and the best essay samples from our writers!