Question
You are an accountant working for a local accounting firm based in Burleigh, Gold Coast. You have been assigned a new client, Juicies, a boutique,
You are an accountant working for a local accounting firm based in Burleigh, Gold Coast. You have been assigned a new client, Juicies, a boutique, family owned ethical business who hand crafts 100% fruit icy poles. Judy and her husband John launched their business in 2020. They are originally from Hawaii and ran a similar business in Hawaii. They were in awe of the top quality fruit available here in Australia and identified a gap in the market for a range of quality ice blocks. They have requested for you to prepare a master budget for Juicies for 2023 which allows them to plan their financial resources, work through "what if" scenarios and help them to make informed decisions to ensure their business continues to grow and operate successfully into the future. The following information has been gathered about their business primarily from the owners themselves: Operations: Juicies operate on a calendar-year basis (Jan - Dec). The business runs out of owned premises in Burleigh, Gold Coast. Their sales team have provided the expected quarterly sales per carton of icy poles. Each carton has 30 ice blocks. Plant and Equipment: Depreciation on the Plant and equipment totals $5,000 per quarter. Cash collections: The Company expects to collect 40% of its credit sales in the quarter of sale and the remaining 60% of credit sales will be collected in the quarter after sales. The company's bad debts are negligible. Payments: The Company plans to pay for 80% of its material purchases within the quarter of purchase and the remaining 20% in the following quarter. Ignore GST and Income Tax. All of the budget assumptions have been provided to you in a budget template ready Using the information provided, i want to prepare master budget for the twelve-month period (4th Quarters) with including 1. A sales budget 2. A production budget 3. A direct materials budget 4. A direct labour budget 5. A manufacturing overhead budget 6. An ending finished goods inventory budget 7. A selling and administrative expense budget 8. A quarterly cash budget 9. A budgeted Income Statement 10. A budgeted Balance Sheet
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started