Question
E10-5 Preparar un presupuesto de gastos generales de fabricacin flexible Fallon Company utiliza presupuestos flexibles para controlar sus gastos de venta. Se espera que las
E10-5 Preparar un presupuesto de gastos generales de fabricacin flexible
Fallon Company utiliza presupuestos flexibles para controlar sus gastos de venta. Se espera que las ventas mensuales oscilen entre $170,000 y $200,000. Los costos variables y su relacin porcentual con las ventas son comisiones de ventas 6%, publicidad 4%, viajes 3% y entrega 2%. Los gastos de venta fijos consistirn en salarios de ventas $35 000, depreciacin del equipo de entrega $7 000 y seguro del equipo de entrega $1 000.
Instrucciones
Prepare un presupuesto mensual flexible para cada incremento de ventas de $10 000 dentro del rango relevante para el ao que finaliza el 31 de diciembre de 2017.
NOTA: Ingrese un nmero en las celdas solicitando un valor; ingrese un nmero o una frmula en las celdas con un "?" .
EMPRESA FALLN Presupuesto flexible de gastos de venta mensuales Para el ao 2017
| Nivel de actividad | ||||||||||
| Los ingresos por ventas | $170,000 | $180,000 | $190,000 | $200,000 | ||||||
| Gastos variables | ||||||||||
| Comisiones de venta (6%) | Elija...$10,200 $12,000 $11,400 7,2007,600$10,800 8,0006,800 | Elija...$10,200 $12,000 $11,400 7,2007,600$10,800 8,0006,800 | Elija...$10,200 $12,000 $11,400 7,2007,600$10,800 8,0006,800 | Elija...$10,200 $12,000 $11,400 7,2007,600$10,800 8,0006,800 | ||||||
| Publicidad (4%) | Elija...$10,200 $12,000 $11,400 7,2007,600$10,800 8,0006,800 | Elija...$10,200 $12,000 $11,400 7,2007,600$10,800 8,0006,800 | Elija...$10,200 $12,000 $11,400 7,2007,600$10,800 8,0006,800 | Elija...$10,200 $12,000 $11,400 7,2007,600$10,800 8,0006,800 | ||||||
| Viajar (3%) | Elija... 4,0005,7003,4003,6005,1003,8005,4006,000 | Elija... 4,0005,7003,4003,6005,1003,8005,4006,000 | Elija... 4,0005,7003,4003,6005,1003,8005,4006,000 | Elija... 4,0005,7003,4003,6005,1003,8005,4006,000 | ||||||
| Entrega (2%) | Elija... 4,0005,7003,4003,6005,1003,8005,4006,000 | Elija... 4,0005,7003,4003,6005,1003,8005,4006,000 | Elija... 4,0005,7003,4003,6005,1003,8005,4006,000 | Elija... 4,0005,7003,4003,6005,1003,8005,4006,000 | ||||||
| Total gastos variables (15%) | Elija... 28,50030,00027,00025,500 | Elija... 28,50030,00027,00025,500 | Elija... 28,50030,00027,00025,500 | Elija... 28,50030,00027,00025,500 | ||||||
| Gastos fijos | ||||||||||
| Salarios de ventas | Elija...$68,500 7,00035,00043,0001,000 | Elija...7,0001,00043,000$70,000 35,000 | Elija...35,0007,00043,000$71,500 1,000 | Elija...$73,000 35,0007,0001,00043,000 | ||||||
| Depreciacin | Elija...$68,500 7,00035,00043,0001,000 | Elija...7,0001,00043,000$70,000 35,000 | Elija...35,0007,00043,000$71,500 1,000 | Elija...$73,000 35,0007,0001,00043,000 | ||||||
| Seguro | Elija...$68,500 7,00035,00043,0001,000 | Elija...7,0001,00043,000$70,000 35,000 | Elija...35,0007,00043,000$71,500 1,000 | Elija...$73,000 35,0007,0001,00043,000 | ||||||
| Gastos fijos totales | Elija...$68,500 7,00035,00043,0001,000 | Elija...7,0001,00043,000$70,000 35,000 | Elija...35,0007,00043,000$71,500 1,000 | Elija...$73,000 35,0007,0001,00043,000 | ||||||
| Gastos totales | Elija...$68,500 7,00035,00043,0001,000 | Elija...7,0001,00043,000$70,000 35,000 | Elija...35,0007,00043,000$71,500 1,000 | Elija...$73,000 35,0007,0001,00043,000 | ||||||
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
Human And Social Audit
Authors: N P Agarwal
1st Edition
8176113980, 978-8176113984
