Please solve this question, it's oprating budget

This is the information to solve the operating budget question. just prepare the oprating budget for the next year.

The answer should include the following

the Question: Assume that Genral Motors (GM) hired you as a cost accountant to present and prepare an operating budget for the next year.

The following financial data was given to you in order to prepare the budget.

Assume that Geral Motors (GM) Hired you as a content to present and prepare an operating budget for the extent The following financial data was given to you in ander to prepare the budget Colemine 10,000,000 9,000,000 Column Column Com Sales: Vehicle Brands Chevrolet Cadillac Direct Materials 5% on Chevrolet sales and 4% on Cadillac sales Direct was 14 Workers. 5120 per month Factory overheads Indirect laber Fatory Supervisor 3505 per met Auto parts and sparcs 1.5% on Chevrolet sales and 0.5% on Cadillac sales Depreciation on Machinery Electricity Other utilines Maintaine Admin, marketing & supply chain expenses $133650 per month 10.500 4,500 2,700 5,950 Column4 10,000,000 9,000,000 Columni Column2 Column3 Sales : Vehicle Brands Chevrolet Cadillac Direct Materials 5% on Chvrolet sales and 4% on Cadillac sales Direct wages 14 Workers. $120 per month. Factory overheads Indirect labor Fcatory Supervisor 3508 per month Auto parts and spares 1.5% on Chevrolet sales and 0.5% on Cadillac sales Depreciation on Machinary Electricity Other utilites Maintaince Admin, marketing & supply chain expenses $133650 per month 10,500 4,500 2,700 5,950 Rememebr! that your master budget MUST includse all the following: 1- Sales budget 2- Production cost budget 3. Gross profit 4- Admin, marketing & supply chain budget 5- Budgeted net profit Assume that Geral Motors (GM) Hired you as a content to present and prepare an operating budget for the extent The following financial data was given to you in ander to prepare the budget Colemine 10,000,000 9,000,000 Column Column Com Sales: Vehicle Brands Chevrolet Cadillac Direct Materials 5% on Chevrolet sales and 4% on Cadillac sales Direct was 14 Workers. 5120 per month Factory overheads Indirect laber Fatory Supervisor 3505 per met Auto parts and sparcs 1.5% on Chevrolet sales and 0.5% on Cadillac sales Depreciation on Machinery Electricity Other utilines Maintaine Admin, marketing & supply chain expenses $133650 per month 10.500 4,500 2,700 5,950 Column4 10,000,000 9,000,000 Columni Column2 Column3 Sales : Vehicle Brands Chevrolet Cadillac Direct Materials 5% on Chvrolet sales and 4% on Cadillac sales Direct wages 14 Workers. $120 per month. Factory overheads Indirect labor Fcatory Supervisor 3508 per month Auto parts and spares 1.5% on Chevrolet sales and 0.5% on Cadillac sales Depreciation on Machinary Electricity Other utilites Maintaince Admin, marketing & supply chain expenses $133650 per month 10,500 4,500 2,700 5,950 Rememebr! that your master budget MUST includse all the following: 1- Sales budget 2- Production cost budget 3. Gross profit 4- Admin, marketing & supply chain budget 5- Budgeted net profit