Dubai Cap Sports Shop’s Master Budget Proposal

Exclusively available on Available only on IvyPanda® Made by Human No AI

Executive summary

The project relates to opening a new shop of cap sports in Dubai. The master budget is prepared to forecast revenue and expenses that will incur in the manufacturing and selling of caps. The master budget shows an estimation of different direct and indirect costs that will incur in producing and selling the product. The main purpose of this master budget is to predict the performance of various business operations of the business. The master budget refers to different low-level budgets of a manufacturing company which is prepared after estimations of all functional areas. Different types of budgets are discussed separately in this report along with their discussion.

Introduction

Cap Sport is a new company that specializes in manufacturing caps that are used in various sports. The master budget is prepared by making financial projections of the company in each quarter for the first year. The company plan is to open a new shop to sell its products in Dubai, U.A.E.

Master Budget

The master budget is a plan that comprises of plans for different operational or functional activities of the business. It helps owners and managers to prepare a strategic plan according to financial projections (Vallabhaneni 833). The assumptions about the business are made to prepare a master budget as it is essential to forecast sales and expenses according to the expected market conditions.

Purpose and Benefits of the Master Budget

The main purpose of a master budget is to make estimations of costs and expenses that are likely to incur in the future. The main benefit of the master budget is to analyze the current market and make the decision of investment by analyzing opportunities and risks associated with the new project.

Budget Process

The master budget has no fixed process as it depends on the operations and functions of the business. The main element is to determine the key areas of business and bifurcate it into different small budgets. The key components such as project sales and cash flows, and estimated costs and expenses should be included in the process of budgeting (Vallabhaneni 812). The main elements of the master budget are presented below.

Sales Budget

Sales budget refers to the forecasting of sales predicted by a company based on the market conditions. It contains information about the number of units that are expected to be sold during a particular period and price of each unit. Total revenue is also indicated in it to show the expected revenue that will be generated from sales of the company’s products. The sales budget of Cap Sport is presented in Table 1.

Table 1

Sales Budget

Cap Sport
Forecasted Sales or Sales Budget
For the Year Ending December 31, 2017
Quarters
FirstSecondThirdFourthYearly
Units Sales5,000700012,00015,00039,000
Unit Price$30$30$32$32
Total Revenues$150,000$210,000$384,000$480,000$1,224,000

Table 1 indicates the company’s forecasted sales in the first year. Cap Sport will be able to increase the number of units sold in each quarter as the market size of Dubai is large and there are opportunities for growth. The company would be able to boost its sales in the third quarter to 12,000 units as a major sports event is held every year in this period in Dubai. The high demand for sports accessories will enable the company to increase the unit price of its products in the market.

Production Budget

The production budget determines the number of units of a product that needs to be sold during a specific period and the inventory to be held by the company at the end of each period. The production budget is essential to estimate whether the company can fulfill the demand for its products. The production budget details are provided in Table 2.

Table 2

Production Budget

Cap Sport
Production Budget
For the Year Ending December 31, 2017
Quarters
FirstSecondThirdFourthYearly
Units Sales5,0007,00012,00015,00039,000
Ending Units Planned300325500800800
Beginning inventory(100)(300)(325)(500)(800)
Production Units Planned5,2007,02512,17515,30039,000

The production budget shows that Cap Sport will increase its planned ending inventory gradually in each quarter. The company plans to change its production budget according to the increase in the demand for sports caps in Dubai. The main reason for the high ending inventory in the third and fourth quarter is due to various sports events that will be held in the country.

Direct Material Budget

The direct material budget refers to the budget that includes details of raw material that are required for production. The quarterly budget for the purchase of direct materials is prepared in Table 3.

Table 3

Direct Material Budget

Cap Sport
Direct Material Budget
For the Year Ending December 31, 2017
Quarters
FirstSecondThirdFourthYearly
Units Sales5,0007,00012,00015,00039,000
Direct Material / Unit55555
Production Direct Material25,00035,00060,00075,000195,000
Ending unit Direct Material1,5001,6252,5004,0001,125
Beginning Unit Direct Material-500-750-1,500-1,750-1,250
Budgeted Direct Material Purchases26,00035,87561,00077,250194,875
Additional Cost / Unit2222
Direct Material Purchases$52,000$71,750$122,000$154,500$400,250

The budgeted direct material purchases represent the costs that will be incurred for the purchase of raw materials in each quarter. The additional cost refers to the cost that will be incurred for transferring goods from suppliers to the store of the company. Therefore, it should be included in the cost of raw material.

Direct Labor Budget

The budget provided in Table 4 is based on the number of labor hours and the cost of labor for producing a specific quantity of the company’s product. Also, the direct labor budget is prepared after the production budget that indicates the number of units required for production.

Table 4

Direct Labor Budget

Cap Sport
Direct Labor Budget
For the Year Ending December 31, 2017
Quarters
FirstSecondThirdFourthYearly
Units Sales5,0007,00012,00015,00039,000
Labor Hour / Unit33333
Total Budgeted Hours15,00021,00036,00045,000117,000
Cost per Hour for Direct Labor$2$3$4$4
Total Direct Labor Cost$30,000$63,000$144,000$180,000$417,000

The direct labor budget shows the estimated hours of direct labor that will be utilized for producing the specific number of units in each quarter. There will no change in the number of hours per product as the company cannot compromise on the quality of its products to increase its efficiency. However, the cost per hour of labor will increase in third and fourth quarters followed as the company will increase its working hours to meet the high demand for caps in that period.

Manufacturing Overhead Budget

Manufacturing overhead budget includes all costs of production excluding direct labor and direct material. It is also known as a factory overhead budget that includes all costs incurred for manufacturing a product. It implies that selling and administration costs and expenses are not included in this budget. The manufacturing overhead budget of the company is provided in Table 5 given below.

Table 5

Manufacturing Overhead Budget

Cap Sport
Manufacturing Overhead Budget
For the Year Ending December 31, 2017
Quarters
FirstSecondThirdFourthYearly
Variable costs
Units Sales5,0007,00012,00015,00039,000
Variable Overhead$3$3$3$3
Total Variable cost$15,000$21,000$36,000$45,000$117,000
Fixed Factory Overhead
Rent5,0005,0005,0005,00020,000
Depreciation2,0002,0002,0002,0008,000
Total Fixed Cost$7,000$7,000$7,000$7,000$28,000
Total Factory Overhead$22,000$28,000$43,000$52,000$145,000
Depreciation2,0002,0002,0002,0008,000
Cash Disbursements$20,000$26,000$41,000$50,000$137,000

The total factory overhead of Cap Sport will gradually increase in each quarter due to the increase in production units. Rent and depreciation are equally divided in each quarter as they are fixed. Cash disbursements do not include depreciation as it is a non-cash expense.

Selling and Administrative Budget

Selling and administrative budget is an essential element of the master plan as it includes the details of operating expenditures that will be incurred for delivering products or services to customers. All indirect costs that have no relation to the manufacturing department should be included in this budget (Vallabhaneni 353). The details of selling and administration expenses of Cap Sport are provided in Table 6.

Table 6

Selling and Administration Expenses Budget

Cap Sport
Selling and Administration Expenses Budget
For the Year Ending December 31, 2017
Quarters
FirstSecondThirdFourthYearly
Budgeted Selling Expenses
Sales Commission$2,000$2,000$2,500$2,500$9,000
Freight-out$1,000$1,000$1,000$1,000$4,000
Budgeted Admin. Expenses
Office Rent$500$500$500$500$2,000
Office Salaries$3,000$3,000$3,000$3,000$12,000
Office Supplies$200$200$200$200$800
Miscellaneous Expenses$100$100$100$100$400
Total Selling & Admin. Expense$6,800$6,800$7,300$7,300$28,200

Cost of Goods Manufacturing Budget

The cost of goods manufacturing relates to the cost of goods that were used in the manufacturing of the company’s products. All direct labor costs and manufacturing overheads will be included in the total amount. However, adjustments are required for calculating the cost of direct material by using the formula provided below.

Direct material cost = Cost of purchases of raw material + Cost of beginning raw material – Cost of ending raw material

The details of the cost of goods manufactured budget are provided in Table 7 given below.

Table 7

Cost of Goods Manufactured Budget

Cap Sport
Cost of Goods Manufactured Budget
For the Year Ending December 31, 2017
Quarters
FirstSecondThirdFourthYearly
Purchase of Direct Material$52,000$71,750$122,000$154,500$400,250
Beginning Raw Material10,50011,37517,50028,0005,625
Ending Direct Material-3,500-5,250-10,500-12,250-6,250
Direct Material Cost$59,000$77,875$129,000$170,250$436,125
Direct Labor Cost30,00063,000144,000180,000417,000
Total Manufacturing Costs$20,000$26,000$41,000$50,000$137,000
Total Cost of Good Manufactured$109,000$166,875$314,000$400,250$990,125

Expected Cash Payments

Expected Cash Payments is a schedule of payments to suppliers. It is estimated that 75 percent of the total payments of raw material will be made to suppliers on delivery. However, the rest of the payment that is 25 percent will be paid after three months of the delivery. Therefore, the expected cash payment schedule is prepared in Table 8 accordingly.

Table 8

Expected Cash Payments

Cap Sport
Expected Cash Payments
For the Year Ending December 31, 2017
Quarters
FirstSecondThirdFourthYearly
Accounts Payable Balance$3,000$3,000
Quarter 1 Purchases (a)39,00013,000$52,000
Quarter 2 Purchases (b)53,81317,938$71,750
Quarter 3 Purchases (c)91,50030,500$122,000
Quarter 4 Purchases (d)115,875$115,875
Total Expected Payments$42,000$66,813$109,438$146,375$364,625

Cash Budget

The cash budget is useful to determine estimated cash inflows and cash outflows of the business. It helps in analyzing the need for cash to run a business. The cash budget of Cap Sport is presented in Table 9 that shows the company will borrow two amounts of $100,000 and $200,000 from a bank to pay its due obligations.

Table 9

Cash Budget

Cap Sport
Cash Budget
For the Year Ending December 31, 2017
Quarters
FirstSecondThirdFourthYearly
Opening Balance$200,000$255,200$170,588$236,850$71,395
Cash Receipts56,00078,400144,000180,000458,400
Available Cash$256,000$333,600$314,588$416,8501,321,038
Direct Material42,00066,813109,438146,375364,625
Direct Labor30,00063,000144,000180,000417,000
Factory Overhead22,00010,40011,00011,78055,180
Selling and Admin. Expenses6,8006,8007,3007,30028,200
Equipment Purchases10,00010,000
Cash Surplus/(Deficit)$155,200$176,588$42,850$71,395446,033
Financing:0
Borrowing100,000200,000300,000
Repayments-4000-4000-8,000
Interest-2000-2000-4,000
Net Cash from Financing$100,000($6,000)$194,000$0288,000
Budgeted Ending Cash Balance$255,200$170,588$236,850$71,395$7,340

Income Statement of Cap Sport

The projected income statement of Cap Sport is prepared by incorporating all associated costs and expenses in the cost of goods sold and operating expenses. The income statement of the company shows that it will be able to generate profit in the first year of its business.

Table 10

Income Statement

Cap Sport
Income Statement
For the Year Ending December 31, 2017
Sales (39,000*$31.38)1,224,000
Cost of Goods Sold954,250
Gross Profit269,750
Operating Expenses
Depreciation Expense8,000
Selling and Administration Expenses28,200
Total Expenses36,200
Interest Expense4,000
Income Before Tax229,550
Tax Expense91,820
Net Income$137,730

Conclusion

The master budget plan includes important financial estimations. Therefore, the management of the new shop should focus on preparing sales strategies according to it. The estimation of costs and expenses is useful for preparing a plan for reducing risks that may affect the business and generate a loss for it.

Works Cited

Vallabhaneni, S. Rao. Wiley CIA Excel Exam Review 2016: Part 3, Internal Audit Knowledge Elements. John Wiley & Sons, 2015.

More related papers Related Essay Examples
Cite This paper
You're welcome to use this sample in your assignment. Be sure to cite it correctly

Reference

IvyPanda. (2020, August 15). Dubai Cap Sports Shop's Master Budget. https://ivypanda.com/essays/dubai-cap-sports-shops-master-budget/

Work Cited

"Dubai Cap Sports Shop's Master Budget." IvyPanda, 15 Aug. 2020, ivypanda.com/essays/dubai-cap-sports-shops-master-budget/.

References

IvyPanda. (2020) 'Dubai Cap Sports Shop's Master Budget'. 15 August.

References

IvyPanda. 2020. "Dubai Cap Sports Shop's Master Budget." August 15, 2020. https://ivypanda.com/essays/dubai-cap-sports-shops-master-budget/.

1. IvyPanda. "Dubai Cap Sports Shop's Master Budget." August 15, 2020. https://ivypanda.com/essays/dubai-cap-sports-shops-master-budget/.


Bibliography


IvyPanda. "Dubai Cap Sports Shop's Master Budget." August 15, 2020. https://ivypanda.com/essays/dubai-cap-sports-shops-master-budget/.

If, for any reason, you believe that this content should not be published on our website, please request its removal.
Updated:
This academic paper example has been carefully picked, checked and refined by our editorial team.
No AI was involved: only quilified experts contributed.
You are free to use it for the following purposes:
  • To find inspiration for your paper and overcome writer’s block
  • As a source of information (ensure proper referencing)
  • As a template for you assignment
Privacy Settings

IvyPanda uses cookies and similar technologies to enhance your experience, enabling functionalities such as:

  • Basic site functions
  • Ensuring secure, safe transactions
  • Secure account login
  • Remembering account, browser, and regional preferences
  • Remembering privacy and security settings
  • Analyzing site traffic and usage
  • Personalized search, content, and recommendations
  • Displaying relevant, targeted ads on and off IvyPanda

Please refer to IvyPanda's Cookies Policy and Privacy Policy for detailed information.

Required Cookies & Technologies
Always active

Certain technologies we use are essential for critical functions such as security and site integrity, account authentication, security and privacy preferences, internal site usage and maintenance data, and ensuring the site operates correctly for browsing and transactions.

Site Customization

Cookies and similar technologies are used to enhance your experience by:

  • Remembering general and regional preferences
  • Personalizing content, search, recommendations, and offers

Some functions, such as personalized recommendations, account preferences, or localization, may not work correctly without these technologies. For more details, please refer to IvyPanda's Cookies Policy.

Personalized Advertising

To enable personalized advertising (such as interest-based ads), we may share your data with our marketing and advertising partners using cookies and other technologies. These partners may have their own information collected about you. Turning off the personalized advertising setting won't stop you from seeing IvyPanda ads, but it may make the ads you see less relevant or more repetitive.

Personalized advertising may be considered a "sale" or "sharing" of the information under California and other state privacy laws, and you may have the right to opt out. Turning off personalized advertising allows you to exercise your right to opt out. Learn more in IvyPanda's Cookies Policy and Privacy Policy.

1 / 1